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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28856: Buffer overflow error

1 Answers  


DRG-12223: section name string is a reserved name

1 Answers  


ORA-31495: error in synchronous change table on "string"."string"

1 Answers  


PLS-01703: Cursor name in CLOSE statment must be of length 1

1 Answers  


ORA-28025: missing or null external name

1 Answers  






TNS-00022: INTCTL: missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


ORA-01031: insufficient privileges

1 Answers  


ORA-01293: mounted database required for specified LogMiner options

1 Answers  


SQL-02129: Fetched number of bytes is odd.

1 Answers  


DRG-11821: Payment Required

1 Answers  


NNO-00156: warning: hint number address length number exceeds maximum of number, hint ignored

1 Answers  


ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

1 Answers   CGI,


Categories