Monday, 9 September 2024

Query to find locked sessions of a particular Table

 select a.sid||'|'|| a.serial#||'|'|| a.process

 from gv$session a, gv$locked_object b, dba_objects c

 where b.object_id = c.object_id

 and a.sid = b.session_id

 and OBJECT_NAME=upper('<Table Name>');

No comments:

Post a Comment