Parallel_max_server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Parallel_max_server

  1. #1
    Join Date
    May 2002
    Posts
    163

    Parallel_max_server

    Hello,

    I am running Veritas bckup and using RMAN interface. In the database "recovery_parallelism=32" is set to 32.

    1) Is the value is high enough.
    2) Should I set paralell_max_server=
    ( I read that recovery_parallelism value should not exceed parallel_max_server value)
    3) When should I consider parallel_max_server parameter?
    4) I set my largepool_size, should I choose parallel_automatic_tuning.

    I am using ORACLE 9.2 on HP


    Regards
    Nwcomer
    Student

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    PHP Code:
    PARALLEL_MAX_SERVERS 
    It specifies the maximum number of parallel execution processes and parallel recovery processes for an instance. As demand increases, Oracle increases the number of processes from the number created at instance startup up to this value.It is derived from the values of CPU_COUNT, PARALLEL_AUTOMATIC_TUNING,and PARALLEL_ADAPTIVE_MULTI_USER
    If you set this parameter too low, some queries may not have a parallel execution process available to them during query processing. If you set it too high, memory resource shortages may occur during peak periods, which can degrade performance.

    PHP Code:
    parallel_automatic_tuning 
    When PARALLEL_AUTOMATIC_TUNING is set to true, Oracle determines the default values for parameters that control parallel execution. In addition to setting this parameter, you must specify the PARALLEL clause for the target tables in the system. Oracle then tunes all subsequent parallel operations automatically. As part of the automatic tuning, Oracle will enable the PARALLEL_ADAPTIVE_MULTI_USER parameter. You can override any of the system-provided defaults if desired


    Hope this helps you
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width