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.