ORA-00054: resource busy and acquire with NOWAIT specified

Problem:

ORA-00054: resource busy and acquire with NOWAIT specified ORA-04022: nowait requested, but had to wait to lock dictionary object

Cause:

for eg: Table A is being used requested by a requestor R and from other session Requestor R1 is trying to drop a table the ORA-00054 error occurs.

Action:

- Check the session which is accessing the table for the requestor R.

- Stop / Terminate the session which is causing this lock situation.