1. Forum
  2. Usenet
  3. COMP.DATABASES.ORACLE.MIS

  • Max value to be used in a parallel hint

    From Raja@21:1/5 to All on Thu Mar 31 09:23:45 2016
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)