resource busy and acquire with NOWAIT specified or timeout expired

 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;

For Example:  alter system kill session 'SID,SERIAL#';   

alter system kill session '1158,52938';