Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sawant
Two processes wating to update the rows of a table which
are locked by the other process then deadlock arises.
In a database environment this will often happen because
of not issuing proper row lock commands. Poor design of
front-end application may cause this situation and the
performance of server will reduce drastically.
These locks will be released automatically when a
commit/rollback operation performed or any one of this
processes being killed externally.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What are the four Oracle system processes that must always be up and running for the database to be useable?
How can I create database in oracle?
How to write date and time literals in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to run create database statement again?
What is key preserved table?
What is a sub query and what are the different types of subqueries?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Can we store images in oracle database?
20. Using a set operator, display the client number of all clients who have never placed an order.
What do you mean by group by clause?
How to drop an existing view in oracle?
When system tablespace is created?
How to view the tablespaces in the current database?
What are the different pseudo commands? Explain in general?
