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

Thread: Time Taken for Requests of a Concurrent Program (Parameter = Program in Upper case)

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

    Time Taken for Requests of a Concurrent Program (Parameter = Program in Upper case)

    col ARGUMENT_TEXT format a40;
    col USER_CONCURRENT_PROGRAM_NAME format a40;

    select
    REQUEST_ID,REQUEST_DATE,PHASE_CODE, STATUS_CODE,
    ARGUMENT_TEXT,
    to_char(ACTUAL_START_DATE,'dd-mon-yy hh:mi:ss') Startdt,
    ORACLE_PROCESS_ID,LOGFILE_NAME,
    to_char(ACTUAL_COMPLETION_DATE,'dd-mon-yy hh:mi:ss') Stopdt,
    (ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24 timetaken_hours ,
    clist.USER_CONCURRENT_PROGRAM_NAME
    from fnd_concurrent_requests creq,FND_CONCURRENT_PROGRAMS_VL clist
    where creq.CONCURRENT_PROGRAM_ID= clist.CONCURRENT_PROGRAM_ID
    and upper( clist.USER_CONCURRENT_PROGRAM_NAME)
    like '%program%'
    order by ACTUAL_START_DATE;
    /

+ 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. Script to get duplicated schedules of the same program
    By Amit in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 11-01-2011, 11:05 AM
  4. How do I diagnose a slow running Concurrent Request / Program
    By ajaysingh in forum Concurrent Processing Server / Workflow
    Replies: 1
    Last Post: 10-19-2011, 11:49 AM
  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