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!

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:
    36
    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:
    6
    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)