【DB笔试面试491】如何判断一个存储过程是否正在运行？

SELECT A.SID,
       B.SERIAL#,
       A.OWNER,
       A.OBJECT,
       A.TYPE,
       B.SERVER,
       B.MODULE,
       B.ACTION,
       B.LOGON_TIME
FROM  V$ACCESS  A,
       V$SESSION B
WHERE  A.SID = B.SID(+)
AND    A.TYPE = 'PROCEDURE'
AND    B.STATUS = 'ACTIVE'
AND    A.OBJECT = 'P_TEST_LHR' --注意这里修改成存储过程的名称
;

SELECT *
FROM   V$DB_OBJECT_CACHE
WHERE  TYPE = 'PROCEDURE'
AND    NAME = 'P_TEST_LHR'
AND    LOCKS > 0
AND    PINS > 0;