Blog with ORACLE related posts (mainly PL/SQL programming) and some personal thoughts
Blog com artigos sobre ORACLE (principalmente sobre programação PL/SQL) e alguns pensamentos pessoais.
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.
No comments:
Post a Comment
Os comentários são moderados.
The comments are moderated.