Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > parallel_max_servers

parallel_max_servers

Oracle 11.1.0:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

Parameter Name:parallel_max_servers
Description:maximum parallel query servers per instance
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-00569: Failed to acquire global enqueue.
    Cause: A prior error occurred on one of the instances in the cluster. Typically errors are caused by shared pool resource contention.

    Action: Check for and resolve prior errors on all instances in the cluster. If there is shared pool resource contention, increase the SHARED_POOL_SIZE, DML_LOCKS, PROCESSES, TRANSACTIONS, CLUSTER_DATABASE_INSTANCES and PARALLEL_MAX_SERVERS initialization parameters.

ORA-12810: PARALLEL_MAX_SERVERS must be less than or equal to %s

    Cause: An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value higher than the maximum allowed by the system.

    Action: Set PARALLEL_MAX_SERVERS to a value less than or equal to the maximum specified in the accompanying message and retry.

ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, %s

    Cause: An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than PARALLEL_MAX_SERVERS.

    Action: Set PARALLEL_MIN_SERVERS to a value less than or equal to PARALLEL_MAX_SERVERS (indicated in the accompanying message) and retry.

ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, %s

    Cause: An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value less than PARALLEL_MIN_SERVERS.

    Action: Set PARALLEL_MAX_SERVERS to a value greater than or equal to PARALLEL_MIN_SERVERS value specified in the accompanying message and retry.

ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

    Cause: The max number of parallel servers available for Logical Standby is less than 5 becase of the limit imposed by the too small value of MAX_PARALLEL_SERVERS.

    Action: Adjust the values of the initialization parameters PARALLEL_MAX_SERVERS to be at least 5.

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ parallel_max_servers ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US