Oracle DBA

Deadlock ORA-00060 error August 22, 2011

Filed under: Errors,Oracle — gaphydba @ 11:44 am
What is deadlock?
Deadlock is a situation in which two or more users are waiting for data locked by each other. deadlocks prevent some transactions from continuing to work.
How to resolve deadlock?
We have to do nothing to resolve deadlock error (ORA-00060), oracle automatically detects and resolve the deadlock by rolling back one statement involve in the statement. releasing one set of conflicting row locks.
Why deadlock error occurs?
deadlock is completely application bug. ask DEVELOPER to look into the coding on particular form (query) which raise DEADLOCK.
What is the reason for deadlock?
Deadlocks most often occur when transactions explicitly override the default locking of oracle database. because oracle database not escalate locks and does not use read locks for queries. but does use row-level locking, deadlocks occurs infrequently.
Advertisements
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s