Sunday, March 3, 2013

How to identify what locked PL/SQL package


select * from v$locked_object lo join dba_objects o on lo.object_id = o.object_id
where o.object_name = 'xxPACKAGE NAMExx' and o.object_type = 'PACKAGE';

No comments:

Post a Comment