3 Replies Latest reply on Jan 19, 2017 10:36 PM by Beauty_and_dBest

    Active blocking programs

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      11gR1

      OL5

       

       

      We have concurrent programs pending affected by this blocker. I think this is already running for 8 days?

      Is it okay to kill it (session 4537)? Why is this happening sometimes?

       

      Capture.PNG

      Capture2.PNG

       

      Capture3.PNG

       

       

      Please help...

       

      Kind regards,

      jc

        • 1. Re: Active blocking programs
          2794067

          Hi,

           

          The below sql retrieve the sid information for the running concurrent program and check whether it is active session.

           

          SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id

          FROM apps.fnd_concurrent_requests a,

          apps.fnd_concurrent_processes b,

          gv$process c,

          gv$session d

          WHERE a.controlling_manager = b.concurrent_process_id

          AND c.pid = b.oracle_process_id

          AND b.session_id=d.audsid

          AND a.request_id =&req_id

          AND a.phase_code = 'R';

           

          Also you can use the below sql to find out which sql is running for the above concurrent request id. Wher

           

          select a.sid, a.serial#, b.sql_text

             from v$session a, v$sqlarea b

              where a.sql_address=b.address

               and a.sid = &sid

          • 2. Re: Active blocking programs
            mdtaylor

            Hi jc,

             

            Usually the blocker is a forms user and you can find it with the following SQL:

            SELECT fu.user_name "APPS Username", fu.email_address "Email", vs.username "DB Username", vs.machine "Client Host", vs.process "Client Process",

                   vs.sid "DB SID", vs.serial# "DB Serial #", vs.program "Program", vs.MODULE "Module", vs.action "Action", vs.logon_time "Login Time",

                   vp.spid "Server Process"

              FROM v$session vs, v$process vp, fnd_logins fl, fnd_user fu, dba_blockers dbl

            WHERE vp.addr(+) = vs.paddr

               AND fl.pid(+) = vp.pid

               AND fl.end_time(+) IS NULL

               AND vs.sid = dbl.holding_session

               AND fu.user_id(+) = fl.user_id;

             

            Any forms session older than your session_timeout is probably a left over shadow process from a user who got disconnected that needs to be killed, especially anything older than a day.

             

            Regards,

            Michael

            • 3. Re: Active blocking programs
              Beauty_and_dBest

              Thanks all