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

--检查数据库是否存在锁
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);