Database Administration (MOSC)

MOSC Banner

Script to determine session on packages ?

edited Feb 23, 2012 3:08AM in Database Administration (MOSC) 1 commentAnswered
 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
b.sid = a.session_id
and
a.object_id = c.object_id
and c.object_name='TABLE_REPORT';

   How apply to package ?

   Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center