Friday, March 22, 2013

Locked object details of a spcefic database sessions


select substr(c.object_name,1,30),c.object_type,
   b.sid,
   b.serial#,
substr(b.module,1,25),
substr(b.action,1,30)
from
   v$locked_object a ,
   v$session b,
   dba_objects c
where  b.sid = a.session_id
and a.object_id = c.object_id and b.sid=1383;

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...