ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

Problem :

ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

Solutions :

+ (Check the datafile size)

  • Show Oracle Session;
SELECT
    O.OBJECT_NAME,
    S.SID,
    S.SERIAL#,
    P.SPID,
    S.PROGRAM,
    SQ.SQL_FULLTEXT,
    S.LOGON_TIME
FROM
    V$LOCKED_OBJECT L,
    DBA_OBJECTS O,
    V$SESSION S,
    V$PROCESS P,
    V$SQL SQ
WHERE
    L.OBJECT_ID = O.OBJECT_ID
    AND L.SESSION_ID = S.SID
    AND S.PADDR = P.ADDR
    AND S.SQL_ADDRESS = SQ.ADDRESS;

Output like this,

Ekran Resmi 2017-12-06 14.40.37

kill like

alter system kill session 'SID,SERIAL#';

(For example) ,

alter system kill session '198,473'😉

Hits: 1

Leave a Reply

Your email address will not be published. Required fields are marked *