2009-01-30

Who is locking my package?

Here is a code that allows to find out which session/user is using a package (effectively locking it).
change the <package_name> words in the code for your package name :-)



select
s.sid,s.process, s.username,s.machine, s.program,s.osuser
from
v$session s, v$sqltext t
where
s.sql_address = t.address
and
t.sql_text like '%<package_name>%';

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.