Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Trace A Concurrent Program

    Uploaded by

    Venkatesh Vykuntam
    To trace a concurrent program: 1. Define the concurrent program and enable tracing by checking the "Enable Trace" box before saving. 2. Run the concurrent program as a request. 3. A SQL trace file will be generated in the ../udump directory on the database server.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Trace A Concurrent Program

    Uploaded by

    Venkatesh Vykuntam
    21 views1 page
    To trace a concurrent program: 1. Define the concurrent program and enable tracing by checking the "Enable Trace" box before saving. 2. Run the concurrent program as a request. 3. A SQL trace file will be generated in the ../udump directory on the database server.

    Original Description:

    concurrent program

    Original Title

    Trace a Concurrent Program

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    To trace a concurrent program: 1. Define the concurrent program and enable tracing by checking the "Enable Trace" box before saving. 2. Run the concurrent program as a request. 3. A SQL trace file will be generated in the ../udump directory on the database server.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    21 views1 page

    Trace A Concurrent Program

    Uploaded by

    Venkatesh Vykuntam
    To trace a concurrent program: 1. Define the concurrent program and enable tracing by checking the "Enable Trace" box before saving. 2. Run the concurrent program as a request. 3. A SQL trace file will be generated in the ../udump directory on the database server.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 1

    HOWTOTraceaconcurrentprogram

    1. Go to System Administrator >> Concurrent >> Program >> Define


    2. Query back the concurrent program that you want to trace.
    3. Click Enable Trace and save it.
    4. Run the concurrent program as a concurrent request
    5. A SQL trace file will be saved in the ../udump directory on the database server

    (OR)
    How do you enable/disable a trace to a Concurrent Program?
    1. Connect to Oracle Applications
    2. Navigate to System Administrator->Concurrent->Program->Define
    3. Query the concurrent program on which you want to enable trace.
    4. Check the enable trace check box bottom of the screen, Save it.
    5. Ask the developer to submit the request, Once the request got submitted and completed normal.
    6. Get the spid as select oracle_process_id from apps.fnd_concurrent_requests where
    request_id=456624.
    7. You will get a spid like 12340.
    8. Goto Udump and ls -ltr *12340*.
    9 . You will get trace file.
    Query to Get the Udump Location:

    SQL>SELECT name,value from v$parameter WHERE name like user_dump_dest;


    NAME

    VALUE

    user_dump_dest
    /u2190/app/oracle/product/11.1.0/db_1/admin/orq11_qmnalx1109/diag/rdbms/orq1/orq
    11/trace

    10. tkprof <source_file.trc> <target.prf>

    You might also like