oracle 查看正在运行的存储过程

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