What is a deadlock ? Explain .
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 |
What are the benefits of ordbms?
How to retrieve values from data fields in record variables?
How to increment dates by 1 in oracle?
Can I create users through internet explorer in oracle 10g?
How to delete all rows a table in oracle?
How can I create database in oracle?
What are the types of trigger in oracle?
Explain the features of oracle?
What is the relationship among database, tablespace and data file?
What are the differences between lov and list item?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to update a table row with a record?