Deadlocks

Question

Please answer the below queries

1. what is deadlock in oracle?
2. Dead lock will happen for complete table or only one row?
3. At what time dead lock will occur?
4. Can you give any solution for deadlocks?

Abhishek Jaiswal · Answer

heyy! go through this links for ur all queries of Oracle deadlock http://www.dba-oracle.com/t_deadlock.htm for detailed study visit http://www.soug.ch/fileadmin/user_upload/Newsletter/NL_public/NL_2013_1_Award_Article.pdf :)

Shweta Lodha · Answer

Deadlock is a situation where more than one session want to acquire the data which is locked by someone else. It results due to poor concurrency implementation or say on misuse of locking. Deadlock can happen on single row as well as on entire table. It totally depends on the way how you are accessing data. Oracle automatically detects such situations and rollback the associated statements. More information can be found at: http://www.oracle-base.com/articles/misc/deadlocks.php