Why and how the deadlock situation arises

If one user is already updating the table and it has a lock, the other user cannot access the table to update. then why and how the deadlock situation arises ?
please explain with example.

Questions by rasmitaacharya

Showing Answers 1 - 3 of 3 Answers

prahlad_786

  • Jun 25th, 2010
 

When 2 different  DML executed on the same resource then it leads to dead lock.

Example:

If a resource locked by user A and it also need resource which is locked by user B. B also need a resource which is locked by user A then neither two will complete its execution.

Normally Oracle will resolve the issue by itself by aborting it.

Solution:
1. Increase PCT free decrease the size of data block and data.
2. Add the INITRANS to target table and indexes.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions