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

Thread: concurrent requests that ran for over X minutes

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    concurrent requests that ran for over X minutes

    set lines 300
    set trims on
    set pages 60
    set head on
    ttit off
    btit off
    alter session set nls_Date_format='DD-MON-RRRR HH24:MI';
    accept minutes prompt "Enter runtime minutes limit to report [DEFAULT=60]: "
    col runtime format 9999999 heading "Runtime|[min]"
    col asd format a23 Heading "Start Time"
    col acd format a23 Heading "End Time"
    col cpn format a15 heading "Program"
    col ucpn format a25 trunc heading "Program Name"
    --col logfile_name format a85 heading "Log File" newline
    --col argument_text format a300 heading "Arguments" newline
    SELECT f.request_id
    , TRUNC(((f.actual_completion_date-f.actual_start_date)/(1/24))*60) runtime
    , f.actual_start_date asd
    , f.actual_completion_date acd
    , p.concurrent_program_name,
    , pt.user_concurrent_program_name ucpn
    , f.phase_code
    , f.status_code
    --, f.logfile_name
    --, f.argument_text
    FROM apps.fnd_concurrent_programs p
    , apps.fnd_concurrent_programs_tl pt
    , apps.fnd_concurrent_requests f
    WHERE TRUNC(((f.actual_completion_date-f.actual_start_date)/(1/24))*60) > NVL('&minutes',60)
    and f.concurrent_program_id = p.concurrent_program_id
    and f.program_application_id = p.application_id
    and f.concurrent_program_id = pt.concurrent_program_id
    and f.program_application_id = pt.application_id
    AND pt.language = USERENV('Lang')
    ORDER by f.actual_completion_date-f.actual_start_date desc
    spool a_cm_long_reqs.log
    /

+ Reply to Thread

Similar Threads

  1. Managing alert for concurrent requests
    By dbaANKIT in forum Concurrent Processing Server / Workflow
    Replies: 3
    Last Post: 08-19-2012, 06:57 PM
  2. Concsub to Submit Concurrent Requests
    By dbaANKIT in forum Concurrent Processing Server / Workflow
    Replies: 1
    Last Post: 12-04-2011, 11:47 AM
  3. Script to get all Concurrent Requests pending with CRM
    By Amit in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 11-01-2011, 09:47 AM
  4. Currently Running Concurrent Requests
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:25 PM
  5. List Scheduled Concurrent Requests
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:12 PM

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