1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Concurrent Program Count in Oracle Apps

Discussion in 'Oracle Apps Technical' started by kiran.marla, Mar 9, 2011.

  1. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi all,

    I need the concurrent program name and count (number of times fired) log..
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Re: Concurrent Program Count..

    Code (SQL):
    SELECT
        prog.user_concurrent_program_name, COUNT(prog.user_concurrent_program_name)COUNT
        FROM
        fnd_concurrent_requests req
        ,v$session ses
        ,v$process proc
        ,v$parameter dest
        ,v$parameter dbnm
        ,fnd_concurrent_programs_vl prog
        ,fnd_executables execname
        WHERE    
         req.oracle_process_id=proc.spid(+)
        AND proc.addr = ses.paddr(+)
        AND dest.NAME='user_dump_dest'
        AND dbnm.NAME='db_name'
        AND req.concurrent_program_id = prog.concurrent_program_id
        AND req.program_application_id = prog.application_id
        AND prog.application_id = execname.application_id
        AND prog.executable_id=execname.executable_id
        GROUP BY prog.user_concurrent_program_name
        ORDER BY 2 DESC;
     
    Sadik likes this.