How to Analyze Long Running or Pending Concurrent Requests jobs

a)
1.Run the script for any concurrent request which is going into
pending/running status and upload the output to SR.

Note 134033.1 ANALYZEPENDING.sql Script for Analyzing all Pending Requests
or
Note 134035.1 ANALYZEREQ.SQL – Detailed Analysis of One Concurrent Request

2. Verify the incompatibilities from the concurrent program definition
screen.

Sysadmin -> Concurrent -> Program -> Define ->
Query on the Program name
> Incompatibilities

See
How To Troubleshoot Only One Concurrent Job Running at a Time Note 1504743.1

II)
a. Check the value for the following profile options:

1. ‘Concurrent:Active Request Limit’
2. ‘Concurrent:Sequential Requests’
3. ‘Concurrent:Hold Requests’

They can affect the value of pending requests.

See
Note 740425.1 Active Request Limit Value at Site Level Incorrectly Overrides User Level Setting
Note 372798.1 Concurrent Manager Only Processing One Request At A Time

b. Make sure no programs marked as run alone.

Reference From Oracle SR

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s