Max value to be used in a parallel hint

I am working on Oracle Database 11gR2 Enterprise Edition, Single Instance.

Below are the values taken from v$parameter :

parallel_min_time_threshold	AUTO
parallel_max_servers            40
parallel_servers_target         16
parallel_server                 FALSE
parallel_degree_limit           CPU
parallel_degree_policy          MANUAL
parallel_threads_per_cpu        2
cpu_count	                1

Degree of Parallelism (DOP) = PARALLEL_THREADS_PER_CPU x CPU_COUNT, i.e., 2 * 1 = 2

so,
when using parallel hint on a query (when environment is idle), the max value that i can use is,

a. dop value = 2, or 
b. parallel_servers_target=16, or 
c. parallel_max_servers=40

Please help me on this?

Thanks,
Raja. Received on Thu Mar 31 2016 - 18:23:45 CEST