Query to find session which Cause PL/SQL LOCK TIMER Wait Event in Oracle

Query to find session which Cause PL/SQL LOCK TIMER Wait Event in Oracle

Query:

SELECT vs.sid,vs.inst_id,vs.osuser,vw.event,vw.p1,vw.p2,vw.p3 ,vt.sql_text , vs.program

FROM gv$session_wait vw, gv$sqltext vt , gv$session vs

WHERE vw.event = 'PL/SQL lock timer'

AND vt.address=vs.sql_address

AND vs.inst_id = vw.inst_id

AND vs.sid = vw.sid;

If you like please follow and comment