ORA-00054: resource busy and acquire with NOWAIT specified

 

Resource busy and acquire with NOWAIT specified :ORA-00054

You can also look up the sql,username,machine,port information and get to the actual process which holds the connection

first select the busy session and then kill the busy session with below query

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
  
    alter system kill session 'SID,SERIAL#';
  
    alter system kill session '378,11329'
    alter system kill session '19,13583'