学步园

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

2、select * from v$access where BJECT=upper('PROCEDURE_NAME');