Forgot your password?    
+ Post New Thread
Threads 1 to 19 of 19

Forum: SCRIPTS : Concurrent Requests & Concurrent Request Sessions


Most Viewed Topics
Requests run by a specific Concurrent Manager/Queue within the date range
All Requests run within the date range
Average Pending Time Per Request
Script to get duplicated schedules of the same program
Script to get all Concurrent Requests pending with CRM
Retrieving Concurrent Request Id from the Session SID
Manager that ran a Concurrent Request
Trace File for a Concurrent Request Id
Currently Running Concurrent Requests
Time Taken for Requests of a Concurrent Program (Parameter = Program in Upper case)
pending jobs in queue that should be running
List Scheduled Concurrent Requests
concurrent requests that ran for over X minutes
Long Running Concurrent Requests
SID (Session Id) and SPID (Process id) for a Concurrent Request
cmclean.sql

    • Replies: 0
    • Views: 20,723
    11-14-2012, 11:35 AM Go to last post
    • Replies: 0
    • Views: 2,496
    08-18-2012, 12:53 AM Go to last post
    • Replies: 0
    • Views: 16,286
    11-04-2011, 12:29 PM Go to last post
  1. All Requests run within the date range

    Started by Amit‎, 11-04-2011 12:29 PM
    actual_completion_date, actual_start_date, date range, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, query, requests run, script
    • Replies: 0
    • Views: 14,803
    11-04-2011, 12:29 PM Go to last post
  2. Average Pending Time Per Request

    Started by Hemant‎, 11-01-2011 05:48 PM
    average time, concurrent request, concurrent_queue_name, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, query, script
    • Replies: 0
    • Views: 14,986
    11-01-2011, 05:48 PM Go to last post
  3. Script to get duplicated schedules of the same program

    Started by Amit‎, 11-01-2011 11:05 AM
    11i, duplicate schedules, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, particular user, query, r12, same concurrent program, script
    • Replies: 0
    • Views: 15,418
    11-01-2011, 11:05 AM Go to last post
  4. Script to get all Concurrent Requests pending with CRM

    Started by Amit‎, 11-01-2011 09:47 AM
    11i, conflict resolution, crm, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, manager, pending programs, pending requests, query, r12, script
    • Replies: 0
    • Views: 16,411
    11-01-2011, 09:47 AM Go to last post
  5. Retrieving Concurrent Request Id from the Session SID

    Started by Hemant‎, 10-31-2011 10:07 PM
    concurrent request id, fnd_concurrent_requests, query, sid, spid, v$process, v$session
    • Replies: 0
    • Views: 18,461
    10-31-2011, 10:07 PM Go to last post
  6. Concurrent Users

    Started by Hemant‎, 10-31-2011 08:59 PM
    • Replies: 0
    • Views: 2,505
    10-31-2011, 08:59 PM Go to last post
  7. Manager that ran a Concurrent Request

    Started by Hemant‎, 10-31-2011 08:27 PM
    11i, concurrent request, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, manager, query, r12, script
    • Replies: 0
    • Views: 16,060
    10-31-2011, 08:27 PM Go to last post
  8. Trace File for a Concurrent Request Id

    Started by Hemant‎, 10-31-2011 08:26 PM
    11i, concurrent request id, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, query, r12, request_id, script, trace file
    • Replies: 0
    • Views: 15,157
    10-31-2011, 08:26 PM Go to last post
  9. Currently Running Concurrent Requests

    Started by Hemant‎, 10-31-2011 08:25 PM
    11i, concurrent requests, currently running, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, query, r12, script
    • Replies: 0
    • Views: 15,869
    10-31-2011, 08:25 PM Go to last post
    • Replies: 0
    • Views: 15,372
    10-31-2011, 08:21 PM Go to last post
  10. pending jobs in queue that should be running

    Started by Hemant‎, 10-31-2011 08:17 PM
    11i, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, pending jobs, pending requests, query, queue, r12, script, should be running
    • Replies: 0
    • Views: 14,859
    10-31-2011, 08:17 PM Go to last post
  11. List Scheduled Concurrent Requests

    Started by Hemant‎, 10-31-2011 08:12 PM
    11i, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_requests, list concurrent requests, query, r12, scheduled, script
    • Replies: 0
    • Views: 15,676
    10-31-2011, 08:12 PM Go to last post
  12. concurrent requests that ran for over X minutes

    Started by Hemant‎, 10-31-2011 08:11 PM
    11i, concurrent program, concurrent request, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, over x minutes, query, r12, script, taking more time
    • Replies: 0
    • Views: 15,067
    10-31-2011, 08:11 PM Go to last post
  13. Long Running Concurrent Requests

    Started by Hemant‎, 10-31-2011 08:10 PM
    11i, concurrent request, fnd_concurrent_processes, fnd_concurrent_programs, fnd_concurrent_queues, fnd_concurrent_requests, long running, more time, query, r12, script, too much time
    • Replies: 0
    • Views: 16,953
    10-31-2011, 08:10 PM Go to last post
    • Replies: 0
    • Views: 19,089
    10-31-2011, 08:07 PM Go to last post
  14. cmclean.sql

    Started by Hemant‎, 10-31-2011 06:54 PM
    clean, clean cm status, clone, concurrent, manager, request, unclean shutdown
    • Replies: 0
    • Views: 16,797
    10-31-2011, 06:54 PM Go to last post

+ Post New Thread

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 250 views
Hot thread with unread posts
More than 15 replies or 250 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in 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