0 Replies Latest reply: Feb 27, 2013 3:36 AM by Known_Sword RSS

    Request waiting for approval

    Known_Sword
      Hi,

      I have request that is in status running from last 24 hours and waht it is doing is


      begin PO_REQAPPROVAL_ACTION.APPROVE_DOC (:v1, :v2, :v3, :v4, :v5); end;

      I got this by 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
      vt.address=vs.sql_address
      AND vs.inst_id = vw.inst_id
      AND vs.sid = vw.sid
      and vs.sid=xxxx

      Any idea what it is doing or how i process this or cancel this request or database session?

      thanks