Oracle ORA-00054 Resource Busy And Acquire With Nowait

Buğra PARLAYAN

1 year ago

If you get this error while operating on a table on Oracle Database, it means that the table is being used by someone else.

Error:

ORA-00054: Resource Busy And Acquire With NOWAIT Specified Or Timeout Expired

You can use the code block below to find or kill the person occupying the table.

select
   c.owner,
   c.object_name,
   c.object_type,
   b.sid,
   b.serial#,
   b.status,
   b.osuser,
   b.machine
from
   v$locked_object a,
   v$session b,
   dba_objects c
where
   b.sid = a.session_id
and
   a.object_id = c.object_id;

select

c.owner,

c.object_name,

c.object_type,

b.sid,

b.serial#,

b.status,

b.osuser,

b.machine

from

v$locked_object a,

v$session b,

dba_objects c

where

b.sid = a.session_id

and

a.object_id = c.object_id;

ALTER SYSTEM KILL SESSION 'sid,serial#';

1	ALTER SYSTEM KILL SESSION 'sid,serial#';