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?

Read the rest of this entry »

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

Read the rest of this entry »