Query to find whether the object(table, package, package body etc....) is in use or not.

 

Some times we may require to find a particular object is in use or not. Use below query to find it.

select sid,object from gv$access where object=<object name>;

Replace the object name with actual object name like table name, package name, package body name etc...

If the query returns "0" rows then object is not in use. If query returns some values then it is under use.

Thanks for going through the post...............