Database DataWarehousing (MOSC)

MOSC Banner

The value of parallel_max_server adjusted in alertlog of 12c(12.1.0.2) database is not as per the fo

edited Oct 15, 2015 10:06AM in Database DataWarehousing (MOSC) 4 commentsAnswered

PARALLEL_MAX_SERVERS = PARALLEL_THREADS_PER_CPU * CPU_COUNT * concurrent_parallel_users * 5

If AMM is disabled, the value of concurrent_parallel_users is 1.

If only PGA AMM is enabled, then the value of concurrent_parallel_users is 2.

If both SGA and PGA AMM is enabled, then the value of concurrent_parallel_users is 4.

Starting with 11gR2, the value of PARALLEL_MAX_SERVERS cannot be greater than (PROCESSES -15) per note “How PARALLEL_MAX_SERVERS and PROCESSES Parameters are Related? (Doc ID 1968840.1)”

So in our case,

PARALLEL_MAX_SERVERS  = 2 * 64 * 4 * 5 = 2560, however PROCESSES is 1000…so the value of PARALLEL_MAX_SERVERS should have been 985 as per the formula mentioned

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center