Thursday 21 March 2013

ORA-00054: resource busy and acquire with NOWAIT specified

SQL>  create index abc on xys (object_id) tablespace mytbs;
 create index abc on xys (object_id) tablespace mytbs
                     *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SELECT a.SID, a.serial#
  2  FROM v$session a, v$locked_object b, DBA_OBJECTS c
  3  WHERE b.object_id = c.object_id
  4  AND a.SID = b.session_id AND OBJECT_NAME='XYS';
       SID    SERIAL#
---------- ----------
       158      25604

  • Commit or rollback the statement  causing issue
  • Wait  till  release resources
  • Kill that session using
alter system kill session 'sid,serial#'

No comments: