- OracleApps Epicenter - http://www.oracleappshub.com -

Specialized / Dedicated Concurrent Managers (Enhancing Performance)

Posted By Sanjit Anand On May 11, 2009 @ 11:35 pm In AOL | No Comments

Assume you have a Business Critical "Short Running" (take an example Invoice Printing) Concurrent Request, but it is waiting for the Standard Manager for a long time before the Processing is getting picked up.

Specialized / Dedicated Concurrent Managers

Creating a specialized concurrent managers which is dedicated to some specific concurrent requests which need to be processed in a different way.

Benefits

  1. Speed up Critical Short Running Requests which has long wait time
  2. To avoid Long Running Request during Peak time

Tips that you need to remember

"Avoid creating an excessive specialized managers. It can degrade the performance due polling on queue tables. You need to create specialized managers only if there is a real need"

You can then define a new Specialized Concurrent Manager(Fig 1). And include the specific critical short run Concurrent Request to the new Manager that you created(Fig 2 ,3). . This will ensure all your critical short run Concurrent Requests are not waiting in the queue for longer time.

ConcurrentPrm3

Fig 1

ConcurrentPrm4

Fig 2

ConcurrentPrm5

Fig 3

and then you need to exclude from standard Manager as per fig 4 & 5.

ConcurrentPrm

Fig 4

ConcurrentPrm2

Fig 5

Avoid Long Running Request during Peak time
This helps you to prevents users from executing such "Long Running" request during Peak time. This improves overall performance of the system.

  • Create a Specialized Manager to process the specific 'Long Running' requests.
  • Assign the Specialized Manager with a work shift with Off peak time.
  • Assume, the Users submit the Concurrent Requests during peak time, then it will get assigned to the Specialized Manager.
  • But Specialized Manager will not process it during peak time


Article printed from OracleApps Epicenter: http://www.oracleappshub.com

URL to article: http://www.oracleappshub.com/aol/specialized-dedicated-concurrent-managers-enhancing-performance/

Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.