Oracle: Detect Locked Objects
By admin on Mar 10, 2009 in Oracle
Useful queries at times to resolve locked objeccts in Oracle
To show lock,
select O.object_name,
O.object_type,
S.sid,
S.serial#,
L.oracle_username,
L.os_user_name,
L.locked_mode
from dba_objects O,
v$locked_object L,
v$session S
where O.object_id = L.object_id
and S.sid = L.session_id
To unlock,
ALTER SYSTEM KILL SESSION 'sid, serialid';
