resource busy and acquire with NOWAIT specified: TRUNCATE TABLE "USERS"
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 SXITISMG
- tssx
SQL> ALTER SYSTEM KILL SESSION '43,8907';
- System altered.