Sep 24 2009

List of sessions locked the particular Object

SELECT sid,
serial#,
username,
machine
FROM v$session
WHERE sid IN
(SELECT sid
FROM v$lock
WHERE id1 IN
(SELECT object_id
FROM dba_objects
WHERE object_name =
AND owner = ))

Comments are closed.

Alibi3col theme by Themocracy