首先查找SESSION_ID:
SQL> select session_id from v$locked_object;
SESSION_ID
———-
142
然后根据SESSION_ID查找SID SERIAL:
SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 142;
SID SERIAL# USERNAME OSUSER
———- ———- —————————— ——————————
142 38 SCOTT LILWEN
最后杀掉这个session:
SQL> ALTER SYSTEM KILL SESSION ‘142,38’;