Oracle – Show Locked Objects
By admin on Dec 7, 2007 in side note
To show locked objects in Oracle,
set head off;
set feedback off;
set echo off;
set linesize 200;
SELECT o.owner, o.object_name, o.object_type, o.last_ddl_time, o.status, l.session_id, l.oracle_username, l.locked_mode
FROM dba_objects o, gv$locked_object l
WHERE o.object_id = l.object_id;
Sorry, comments for this entry are closed at this time.