Return to Snippet

Revision: 64410
at August 6, 2013 02:51 by ceduard0


Initial Code
select o.OBJECT_NAME, l.SESSION_ID, l.ORACLE_USERNAME, l.OS_USER_NAME, l.PROCESS
  from V$LOCKED_OBJECT l, USER_OBJECTS o
where o.OBJECT_ID = l.OBJECT_ID;

Initial URL


Initial Description
List locked object Oracle Database using V$LOCKED_OBJECT view

Initial Title
List locked object Oracle Database

Initial Tags
object, Oracle

Initial Language
SQL