oracle查锁解锁

最新推荐文章于 2024-04-26 18:11:35 发布

zhiming99

最新推荐文章于 2024-04-26 18:11:35 发布

阅读量1.2k

点赞数

文章标签： oracle session object system kill user

濮阳医保专栏收录该内容

3 篇文章 0 订阅

订阅专栏

SELECT A.OBJECT_ID,
       B.OBJECT_NAME,
       A.SESSION_ID,
       A.ORACLE_USERNAME,
       A.OS_USER_NAME,
       A.PROCESS,
       A.LOCKED_MODE
  FROM V$LOCKED_OBJECT A, DBA_OBJECTS B
WHERE A.OBJECT_ID = B.OBJECT_ID;

SELECT T2.USERNAME, T2.SID, T2.SERIAL#, T2.LOGON_TIME
  FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID
ORDER BY T2.LOGON_TIME;

ALTER SYSTEM KILL SESSION 'sid, serial#';