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'
