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

ORA-28520: error initializing heterogeneous data dictionary translations

1 Answers  


ORA-03128: connection is in blocking mode

1 Answers  


NID-00452: Succesfully changed database ID.

1 Answers  


QSM-02012: a CONNECT BY clause is present

1 Answers  


ORA-16161: Cannot mix standby and online redo log file members for group string

1 Answers  






QSM-01084: materialized view, string, has anchor, string, not found in query

1 Answers  


DRG-50926: invalid text query string

1 Answers  


NNL-00285: Server has no queued system queries

1 Answers  


ORA-02805: Unable to set handler for SIGTPA

1 Answers  


TNS-04069: Sleeping for number seconds...

1 Answers  


TNS-00001: INTCTL: error while getting command line from the terminal

1 Answers  


DRG-12602: index owner does not have access to user datastore procedure: string

1 Answers  


Categories