Thursday, March 21, 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

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...