Re: Oracle processes and parallel execution server processes

I am not sure what the origional post was, but processes has nothing to do with either parallel server or parallel query. The actual parameter for parallel query is

PARALLEL_MAX_SERVERS
Parameter type: Integer

Parameter class: Static

Default value: Derived from the values of CPU_COUNT, PARALLEL_AUTOMATIC_TUNING, and PARALLEL_ADAPTIVE_MULTI_USER

Range of values: 0 to 3599

Oracle Parallel Server: All instances must have the same value (which can be zero).

Note: This parameter applies to parallel execution in exclusive mode as well as in the Oracle Parallel Server environment.

PARALLEL_MAX_SERVERS 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.

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.

See Also: Oracle8i Designing and Tuning for Performance for more information on tuning parallel execution.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Zhenming" <zmwang_at_maloca.com> wrote in message
news:nA655.990$R2.79343912_at_nr1.ottawa.istar.net...


> I am not sure when executing a parallel operation, the parallel server

> processes are limited by the number specified in the Initialization

> parameter file " PROCESSES", the default is 30.

>

> Zhenming

>

>