Oracle dba账号默认oracle查看锁表用户以及清楚锁信息

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

SELECT OS_USER_NAME,  

OBJECT_NAME,  

SESSION_ID,  

SERIAL#  

FROM V$LOCKED_OBJECT, USER_OBJECTS, V$SEoracle账号SSION  

WHERE V$LOCKED_OBJECT.OBJECT_ID = USER_OBJECTS.OBJECT_ID  

AND V$LOCKED_OBJECT.SESSION_ID = V$SESSION.SID  

查看 是否 存在 锁表信息

查询到的SESSION_ID和SERIAL#执行

[sql] 

ALTER   SYSTEM   KILL   SESSION  '48,2476'–(48为SESSION_ID的值, 2476为SERIAL#的值)