检查数据库是否存在锁和检查实时执行计划

--检查数据库是否存在锁

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);