Oracle ORA-00054 Resource Busy And Acquire With Nowait

Buğra PARLAYAN December 12, 2022 ORACLE

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#';

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Oracle ORA-00054 Resource Busy And Acquire With Nowait

Error:

About Buğra PARLAYAN

Leave a Reply Cancel reply

Categories