oracle 查看锁表用户以及清楚锁信息

1. SELECT?OS_USER_NAME,??OBJECT_NAME,??
2. SESSION_ID,??SERIAL#??
3. FROM?V$LOCKED_OBJECT,?USER_OBJECTS,?V$SESSION??WHERE?V$LOCKED_OBJECT.OBJECT_ID?=?USER_OBJECTS.OBJECT_ID??
4. AND?V$LOCKED_OBJECT.SESSION_ID?=?V$SESSION.SID??

查看 是否 存在 锁表信息

查询到的SESSION_ID和SERIAL#执行

1. ALTER???SYSTEM???KILL???SESSION??'48,2476'--(48为SESSION_ID的值,?2476为SERIAL#的值)?