--产看那张表被锁
SELECT
MACHINE,
PROGRAM,
A.OS_USER_NAME, --机器用户名
C.OWNER,
A.oracle_username, -- 登录用户
A.OBJECT_ID,--锁对象ID
C.OBJECT_NAME, --被锁对象名
A.locked_mode, --锁模式
B.STATUS,--ACTIVE:当前正在执行SQL语句(waiting for/using a resource);?INACTIVE:等待操作(即等待需要执行的SQL语句);?KILLED:标记为终止,删除;?CACHED:为Oracle*XA使用而临时高速缓存;?SNIPED:会话不活动,在客户机上等待,该状态不再被允许变为ACTIVE。
/*STATE,*/
B.SID,
B.SERIAL#,
B.LOGON_TIME --登录数据库时间
FROM V$LOCKED_OBJECT A, V$SESSION B, DBA_OBJECTS C
WHERE A.SESSION_ID = B.SID
AND A.OBJECT_ID = C.OBJECT_ID
ORDER BY B.LOGON_TIME;
--解锁
ALTER SYSTEM KILL SESSION 'sid,serial#' --'sid,serial#'
--被锁的SQL语句
SELECT
B.USERNAME,B.SID,B.SERIAL#,C.*
FROM V$LOCKED_OBJECT A,V$SESSION B,V$SQL C
WHERE A.SESSION_ID = B.SID AND B.SQL_ID = C.SQL_ID AND SID IN('11740','11980')
ORDER BY B.LOGON_TIME;
木庄网络博客(2016/10/28 11:41:03)
不错的网站主题,看着相当舒服