You are currently browsing the tag archive for the ‘ORA-00054’ tag.

You can hit ORA-00054: resource busy and acquire with NOWAIT specified error during some of your operations on your database such as alter some objects.

The main reason for this error is Table Level Locks(TM lock). The transaction holds two locks (Row Locks(TX) and Table Locks(TM) when the session opens. So What are those locks?

Yazının devamını oku »

You can hit ORA-00054: resource busy and acquire with NOWAIT specified error during some of your operation on your database.

Yazının devamını oku »