oracle查看锁表用户以及清楚锁信息
oracle查看锁表用户以及清楚锁信息SELECT OS_USER_NAME,OBJECT_NAME,SESSION_ID,SERIAL#FROM V$LOCKED_OBJECT, USER_OBJECTS, V$SESSIONWHERE V$LOCKED_OBJECT.OBJECT_ID = USER_OBJECTS.OBJECT_IDAND V$LOCKED_OBJECT.SESSION_ID = V$SESSION.SID查看 是否 存在 锁表信息查询到的SESSION_ID和SERIAL#执行[sql]ALTER SYSTEM KILL SESSION '48,2476'--(48为SESSION_ID的值, 2476为SERIAL#的值)