Script to determine session on packages ?
Hi all,
I have been used bellow script to determine sessions are using on some tables but to package seem as it not effect.
select
b.username,c.object_name,b.sid,b.serial#,b.machine
from
gv$locked_object a ,gv$session b,dba_objects c
where
How apply to package ?b.sid = a.session_idanda.object_id = c.object_idand c.object_name='TABLE_REPORT';
Thanks.
0