How to Identify the sql which cause PL/SQL LOCK TIMER wait event

PL/SQL LOCK TIMER wait event.

How to identify the SQL statement which causes high PL/SQL LOCK TIMER wait event that may appear in statspack reports?

Solution

Please use the below query:

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

Related Posts