Passionate Engineer, Technology Leader, Bootstrap Specialist, Software Architect, Success Stories Creator, Hard to get discouraged team player!
Thursday, September 29, 2011
How to defect Oracle locked objects?
SELECT a.sid, a.serial#, a.username, c.os_user_name, a.terminal, b.object_id, SUBSTR(b.object_name,1,40) object_name FROM v$session a, dba_objects b, v$locked_object c WHERE a.sid = c.session_id AND b.object_id = c.object_id
No comments:
Post a Comment