PARALLEL_MAX_SERVERS parameter controls the number of parallel servers.
Also, please check if the tables have object level parallelism enabled (DEGREE column). If the parallel hint in the query is 2 and DEGREE is 2 for the table used in the query then you will see 4 parallel servers running.
Thanks,




Reply With Quote