1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. 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!

Query for Identifying the Concurrent Program Trace file Path location

Discussion in 'Oracle Apps Technical' started by malli_18arjun, Oct 1, 2010.

  1. malli_18arjun

    malli_18arjun Active Member

    Messages:
    34
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Hyderabad
    Introduction

    The following query helps to identify the Trace file path location for a particular Concurrent Request

    Pass the request id as parameter

    SQL Code:
    Code (SQL):
        SELECT
        req.request_id
        ,req.logfile_node_name node
        ,req.oracle_Process_id
        ,req.enable_trace
        ,dest.VALUE||'/'||LOWER(dbnm.VALUE)||'_ora_'||oracle_process_id||'.trc' trace_filename
        ,prog.user_concurrent_program_name
        ,execname.execution_file_name
        ,execname.subroutine_name
        ,phase_code
        ,status_code
        ,ses.SID
        ,ses.serial#
        ,ses.module
        ,ses.machine
        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 1=1
        AND req.request_id = &request --Request ID
        AND 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
    Thanks
    Malli
     
  2. hareesh

    hareesh Guest

    Hi

    this is very useful to me real time environment
     
  3. banksilp

    banksilp Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Dear Malli,

    Big tanks from thailand , it's very useful.

    Phatsakon U.
     
  4. karthikeyang84

    karthikeyang84 Active Member

    Messages:
    16
    Likes Received:
    5
    Trophy Points:
    110
    Location:
    Hosur
    Hi,

    Thanks... Useful information to DBA / Technical users.


    Regards
    G.Karthikeyan.:)
     
  5. lqq250700

    lqq250700 Guest

    How To Trace a Concurrent Request And Generate TKPROF File (Doc ID 453527.1)