--检查数据库是否存在锁
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,type,id1,id2,lmode,request,ctime,block
FROM v$lock WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM v$lock WHERE request >0) ORDER BY id1, request;
--检查实时执行计划
SELECT *
FROM V$SQL_PLAN
WHERE (HASH_VALUE, CHILD_NUMBER) =
(SELECT SQL_HASH_VALUE, SQL_CHILD_NUMBER
FROM V$SESSION
WHERE SID = 2770);
检查数据库是否存在锁和检查实时执行计划
最新推荐文章于 2022-06-27 09:48:22 发布