Copy of Oracle FAQ ORACLE RECOVERY without DUL
ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD INFO | ORAFAQ SEARCH | ORAFAQ E-MAIL
 

Index > ORACLE Server Parameters > pga_aggregate_target

pga_aggregate_target

Oracle 10.0.1:

Paramter Name:pga_aggregate_target
Description:Target size for the aggregate PGA memory consumed by the instance
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Paramter Name:pga_aggregate_target
Description:Target size for the aggregate PGA memory consumed by the instanc
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-04032: pga_aggregate_target must be set before switching to auto mode
    Cause: attempt to set workarea_size_policy to AUTO while pga_aggregate_target is not specified

    Action: before setting workarea_size_policy, set pga_aggregate_target to a value representing the total private memory available to the instance. This total is generally the total physical memory available in the system minus what is needed for the SGA minus what is needed for the operating system (e.g. 500MB)

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

ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD FAQ | ORAFAQ SEARCH | ORAFAQ E-MAIL
All content of this page is copy from www.orafaq.com