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

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