RSS Feed for This PostCurrent Article

Oracle: Detect Locked Objects

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';


Trackback URL


Sorry, comments for this entry are closed at this time.