Answer / 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|
How to increment dates by 1 in oracle?
Why does oracle 9i treat an empty string as null?
How to create a temporary table in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
what are archived logs?
which language is used to develop the oracle........?
How to get last row id?
What are Clusters ?
Difference between oracle's plus (+) notation and ansi join notation?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
how to retrieve daily sal from emp table in oracle 10g