f



Max value to be used in a parallel hint

Hi,

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.
0
Raja
3/31/2016 4:23:45 PM
comp.databases.oracle.misc 8436 articles. 1 followers. Post Follow

0 Replies
212 Views

Similar Articles

[PageSpeed] 4

Reply: