Select Page

Oracle ORA-00054: resource busy and acquire with NOWAIT specified

Oracle ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00054: resource busy and acquire with NOWAIT specified
Cause: Resource interested is busy.
Action: Retry if necessary.

I show you here how to get around this error and kill the sessions that are preventing the exclusive lock.

Note that you could also (preferred)

  • Run your changes later when the database is idle.
  • Do all DDL during a maintenance window when all users are not logged in

Run in SQL*Plus or SQL developer

select a.sid, a.serial#  from v$session a, v$locked_object b, dba_objects c  where b.object_id = c.object_id  and a.sid = b.session_id and OBJECT_NAME='YouTableName';

Then note both the sid and serial and run

alter system kill  session 'sid,serial#' IMMEDIATE;

If this still do not work, your last bullet is to kill the Unix process which is still hanging on your database server!

here is how to find the unix process to kill

Run in SQL*Plus or SQL developer

select p.spid,s.sid,s.serial#,s.username,s.status,s.last_call_et,
p.program,p.terminal,logon_time,module,s.osuser from V$process p,V$session s where s.paddr = p.addr and s.status = 'ACTIVE' and
s.username not like '%SYS%';

and finally run a

kill –9 spid

if this still don’t not work, your best friend is Google

About The Author

Cédric Walter

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology. In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions. I'm the Founder and CEO of Disruptr GmbH.



Cordalo simplify writing Corda applications. is a blog / digital playground where Cédric keep track of new developments in the distributed ledger technology space and present all his experimentation and tools, promoting the understanding of digital currencies and assets.
Galaxiis premium joomla extensions and plugins is a blog about the Audi R8 Spyder V10 and more...