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!

Update a row waiting for lock (Mode=6) but no blocking session found for this row

EnjoyToHelpAug 8 2016 — edited Aug 12 2016

Hi,

We are trying to update a particular row of table but update is waiting to have a lock(Mode=6) on this row and waiting forever.

Query Is :

Update s03_txn.T_TXN_DTL set TXD_CREATION_SEQ = 631064807 where TXD_TRANSACTION_DTL_ID =120056496;

But If we try to update the row using select for update nowait then getting below error :

ORA-00054 : resource busy and acquire with NOWAIT specified or timeout expired.

But no blocker has been found. Can anyone help on this to find what is real cause of the blocking.

Oracle Version is 11.2.0.3 and OS is AIX 6.1 and Production Environment.

Regards,

Dip

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2016

Added on Aug 8 2016

#general-database-discussions

22 comments

3,533 views