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 > sga_max_size

sga_max_size

Oracle 10.0.1:

Paramter Name:sga_max_size
Description:max total SGA size
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 9.2.0:

Paramter Name:sga_max_size
Description:max total SGA size
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

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-00820: Specified value of sga_max_size is too small, needs to be at least %sM
    Cause: The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.

    Action: Set sga_max_size to the recommended value or reduce the values of any SGA component size parameters you have specified.

ORA-00823: Specified value of sga_target greater than sga_max_size

    Cause: The specified value of sga_target is greater than sga_max_size.

    Action: Increase sga_max_size to match up with sga_target or decrease sga_target to match up with sga_maxsize.

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ sga_max_size ] 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