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
Hi Can any one tell me what are the API's used in requisition import.
Explain what are synonyms used for?
Differentiate between pre-select and pre-query?
What is an oracle data file?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How can we delete duplicate rows in a table?
How to Truncate Table in Oracle
Will you be able to store pictures in the database?explain.
How to connect to oracle using service name instead of sid?
How many types of cluster table in Oracle?
what are archived logs?
How do I manually uninstall oracle client?
List out the difference between commit, rollback, and savepoint?
Difference between cartesian join and cross join?
What is the usage of control file in oracle?