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.

Cheers!

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.

Discussion

One thought 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

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

Traffic

Site Stats

  • 631,744 views since Feb 2012

Archives

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

Join 193 other followers

Flags

Free counters!
Follow

Get every new post delivered to your Inbox.

Join 193 other followers

%d bloggers like this: