You're reading...
Admin, Concurrent Program

How to change priority for a concurrent request

Normally, multiple developers work on a single Oracle development instance. Sometimes someone could be working on development of programs which can spawn a lot of long running concurrent requests from a single request. There could be situations where multiple users have executed long running requests simultaneously. The maximum number of requests that can be handled by the concurrent manager is set by the DBAs based on the amount of load the server can handle.

If there is a long queue of requests and you execute a request then the request needs to wait until the concurrent manager is free to process this request. Until then the request will be automatically kept in Pending stage.

If you need to execute the request urgently, what do you do? You will need to change the priority of the request for the concurrent manager to pick this request before the other requests.

Check this out. I had executed the standard concurrent program, Workflow Background Process. This request takes a minute to complete but it is in Pending stage as someone has executed multiple requests, EY DSR Invoice Validation and the concurrent manager will need time to pick up my request.

I fired the concurrent request from SRS form and I saw the request as below

Clicking on View Details button for the request of Workflow Background Process, on the SRS form, I found that its Priority is set to 50 by the Concurrent Manager.

Note that the field, Priority, is non editable

On the menu I clicked on Tools > Manager and I found that the Concurrent Manager is executing 5 requests. There are 16 requests pending and my request is in the 14th position.

I clicked on Manager Queue button to view the requests

I changed responsibility to System Administrator. I clicked on Concurrent > Request on Navigator menu.

Then I clicked on View Details button for the request

Now I see that Priority can be updated. I changed the priority to 1

I clicked OK.

Now the program has got the highest priority and starts running as soon as the Concurrent Manager finished running the current running request.


About these ads

About Abhijit

I love sleeping, watching Hollywood blockbusters, my Wii, road trips and watching my 4 year old son grow up. In between I try to squeeze in some time to go to work.


2 thoughts on “How to change priority for a concurrent request

  1. I’m now not sure where you’re getting your information, however good topic.
    I must spend some time learning much more or figuring out more.
    Thank you for fantastic info I used to be searching for this info
    for my mission.

    Posted by minecraft games | April 24, 2014, 7:48 pm
  2. Howdy! I could have sworn I’ve been to this site before but after checking through some of the post I realized it’s
    new to me. Anyhow, I’m definitely delighted I found it and I’ll
    be book-marking and checking back frequently!

    Posted by Diet Plans for Women to Lose Weight | September 20, 2014, 11:30 am

Leave a Reply

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

You are commenting using your 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


Site Stats

  • 729,800 views since Feb 2012


Enter your email address to follow this blog and receive notifications of new posts by email.

Join 215 other followers


Free counters!

Get every new post delivered to your Inbox.

Join 215 other followers

%d bloggers like this: