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-01769: duplicate CLUSTER option specifications

1 Answers  


NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded

1 Answers  


ORA-19682: file string not in block media recovery context

1 Answers  


ORA-31040: Property string: XML type (string) not compatible with internal memory type (string)

1 Answers  


PCC-02413: Number of attributes does not match number of host variables

1 Answers  


TNS-04021: The SET command is unsuccessful for parameter string.

1 Answers  


TNS-00012: INTCTL: error while processing Connection Manager request

1 Answers  


ORA-00154: protocol error in transaction monitor

1 Answers  


ORA-39018: master process received invalid message number string

1 Answers  


ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers

1 Answers  


TNS-00003: INTCTL: error while sending request to the Interchange

1 Answers  


UDE-00014: invalid value for parameter, 'string'.

1 Answers  


Categories