resource busy and acquire with NOWAIT specified: TRUNCATE TABLE "USERS"

resource busy and acquire with NOWAIT specified: TRUNCATE TABLE USERSSQL select session_id from

resource busy and acquire with NOWAIT specified: TRUNCATE TABLE "USERS"

SQL> select session_id from v$locked_object;


SESSION_ID----------        43
SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 43;


       SID    SERIAL# USERNAME---------- ---------- ------------------------------OSUSER------------------------------        43       8907 SXITISMGtssx

SQL> ALTER SYSTEM KILL SESSION '43,8907';


System altered.