Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

deadlock and lock

Mohamed HouriJan 8 2010 — edited Jan 8 2010

Dears,

I have a situation where from time to time there is an enq : TX- row lock contention in the database and many other sessions are blocked until the DBA kills the blocked session. From time to time I have also a deadlock situations that are cleared automatically by Oracle.

But the Oracle Entreprise manager is showing in one situation the enq : TX- row lock contention and it mentions also this *"A deadlock has been detected in the blocked sessions"*

Does this mean that both a deadlock and a lock happens at the same time?

If no, is this situation possible?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2010

Added on Jan 8 2010

#general-database-discussions

1 comment

901 views