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-26526: materialized view sql ddl parse/expansion failed for string.string

1 Answers  


PCC-00109: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL

1 Answers  


ORA-14036: partition bound value too large for column

1 Answers  


ORA-02048: attempt to begin distributed transaction without logging on

1 Answers  


DRG-12508: null stop words are not allowed

1 Answers  






ORA-01628: max # extents (string) reached for rollback segment string

1 Answers  


ORA-31521: CDC subscription string already subscribes to publication ID string column string

1 Answers  


ORA-30393: a query block in the statement did not rewrite

1 Answers  


ORA-14402: updating partition key column would cause a partition change

2 Answers  


ORA-25305: enqueue failed, expiration must be zero for queue string.string

1 Answers  


TNS-00209: Tracing : string

1 Answers  


ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.

1 Answers  


Categories