【Oracle】查看正在运行的存储过程

select name from v$db_object_cache where locks > 0 and pins > 0 and type='PROCEDURE';