|
Index >
ORACLE Server Parameters >
sga_max_size
sga_max_size
Oracle 11.1.0:
| Parameter Name: | sga_max_size
| | Description: | max total SGA size
| | Type: | TYPE=6
| Obsoleted: | TRUE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 10.2.0:
| Parameter Name: | sga_max_size
| | Description: | max total SGA size
| | Type: | TYPE=6
| Obsoleted: | TRUE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 10.1.0:
| Parameter 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:
| Parameter 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 %sMCause: 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.
| 
