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