My Oracle Support Banner

PARALLEL_MAX_SERVERS value for ASAP application (Doc ID 2554752.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Communications ASAP - Version 7.2.0 and later
Information in this document applies to any platform.

Goal

PARALLEL_MAX_SERVERS (enabled and set to 1920 for ASAP DB environment), using lots of parallel processes regularly, and this is causing high CPU and memory usage.

Would like to minimize the value to 120 or lower.  It might downgrade the queries from parallel to serial. If so, then it might further require tuning of those queries, so that without parallel, it should run in optimized fashion.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.