--查看正在运行的存储过程
select b.sid,b.SERIAL#
from SYS.V_$ACCESS a, SYS.V_$session b
where a.type = 'PROCEDURE'
and (a.OBJECT like upper('%ZZ_Z%') or a.OBJECT like lower('%ZZ_Z%'))
and a.sid = b.sid
and b.status = 'ACTIVE';
【Oracle】查看正在运行的存储过程
于 2016-02-01 10:16:57 首次发布