The value of parallel_max_server adjusted in alertlog of 12c(12.1.0.2) database is not as per the fo
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