sga_target

Oracle 11.1.0:

Oracle 10.2.0:

Oracle 10.1.0:

Oracle 9.2.0:

Oracle 8.1.7:

Oracle 8.0.6:

Oracle 7.3.4:

Related Error Messages:

Cause: The specified value of sga_target 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_target 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.

ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information

Cause: Unable to set sga_target due to current parameter settings.

Action: See alert log for more information.

ORA-00825: cannot set db_block_buffers if sga_target set

Cause: sga_target set with db_block_buffers set.

Action: Do not set sga_target or use new cache parameters and do not use db_block_buffers which is a old cache parameter.

ORA-00826: cannot set sga_target for an ASM instance

Cause: sga_target set for an ASM instance.

Action: Do not set sga_target.

ORA-00827: could not shrink sga_target to specified value

Cause: Attempted to shrink the SGA to the specified value but did not succeed because the SGA components could not be shrunk as they were already at their minimum sizes.

Action: Do not set sga_target to a value below the current value without first shrinking the individual SGA components.

ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings

Cause: Unable to set shared_pool_reserved_size to specified value if sga_target set, either because the specified value is too small, or because it is too large for the current internal size of shared pool. More details can be found in the alert log.

Action: If possible, do not set shared_pool_reserved_size without setting shared_pool_size if sga_target set. Examine the alert log for information about current internal size of shared pool, and valid range of values for shared_pool_reserved_size.

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