- 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#的值)?