Here is the best. A few years ago whist on a site in the USA, a consultant requested and to my disbelief secured a 6 months assignment to review and design a new concurrent configuration. Six (6) months for what can be done in less than a week!

The paper was originally written when 11.0 was the latest release, so I have updated the paper screen shots to reflect 12i.

I hope you find it useful.

Abstract

This paper will review three (3) real world concurrent manager configurations, it will discuss in detail each of the configurations, identify the advantages and disadvantages of each configuration and the issues caused by inappropriate configurations. The paper will specifically focus on the details of each configuration, including:

• Appropriateness of the number of concurrent managers
• Configuration and usage of Custom Managers including FSG
• Appropriate Work Shifts
• High transaction rate managers
• The impact on the application
• The impact on the business
• Alternative configurations, i.e. corrective action

• Case 1: Too many managers
• Case 2: Sleep and cache settings
• Case 3: Specialization rules