- SELECT OS_USER_NAME,
- OBJECT_NAME,
- SESSION_ID,
- SERIAL#
- FROM V$LOCKED_OBJECT, USER_OBJECTS, V$SESSION
- WHERE V$LOCKED_OBJECT.OBJECT_ID = USER_OBJECTS.OBJECT_ID
- AND V$LOCKED_OBJECT.SESSION_ID = V$SESSION.SID
查看 是否 存在 锁表信息
查询到的SESSION_ID和SERIAL#执行
- ALTER SYSTEM KILL SESSION '48,2476'--(48为SESSION_ID的值, 2476为SERIAL#的值)