Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: How do I diagnose a slow running Concurrent Request / Program

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    How do I diagnose a slow running Concurrent Request / Program

    If concurrent program is taking lot of time what could be the approach to diagnose?
    I think we take trace {Enable Trace} of that concurrent program and get the sql and analyse it.
    What could be other way or further action?
    Is there any sql provided by oracle for diagnosis of concurrent programs especially?

    My point is how can we diagnose the bottleneck of concurrent program slowness?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Check on the state of the request ; Is the manager who should run the conc request having sufficient processes.

    Apart from tracing ,

    If the Concurrent program is currently running , here is a guideline

    1) get the SID for the concurrent request.

    2) Examine the session waits for the session - it could be that it is waiting on enqueue or waiting on latches ..or some other issue

    3) Examine the sql for the session and get its execution plan. Check the plan and costs involved to diagnose if the execution plan is proper.
    See when the stats for the relevant tables /schemas were gathered.

    4) Check the CPU & Utilisation of the Server.Get the OS Process Id for the Concurrent request and check its CPU Utilization

    5) Check - has the pending time been high or the Running time.

    6) If Pending time is high , you may need to increase cache & processes , reduce sleep time
    The request could also be pending on account of incopatibilities with other programs.

    7) Check the request volume when the concurrent request is run and compare with average volumes



    For diagnosing the concurrent requests use the scripts for concurrent requests diagnosis and database session diagnosis given in :
    Concurrent-Requests-Scripts
    Concurrent-Manager-and-Concurrent-Users-Scripts
    Database-Scripts

+ Reply to Thread

Similar Threads

  1. Scheduled Concurrent Program failing but Same program run successfull on manual run
    By himsinha in forum Concurrent Processing Server / Workflow
    Replies: 1
    Last Post: 11-29-2012, 06:25 PM
  2. Purge Obsolete Workflow Runtime Data Concurrent Program
    By Hemant in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 11-07-2011, 11:11 PM
  3. Manager that ran a Concurrent Request
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:27 PM
  4. Time Taken for Requests of a Concurrent Program (Parameter = Program in Upper case)
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:21 PM
  5. How do I diagnose a slow running Concurrent Request / Program
    By ajaysingh in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 10-19-2011, 11:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics