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-01600: at most one "string" in clause "string" of string

1 Answers  


ORA-01166: file number string is larger than string (string)

1 Answers  


ORA-31635: unable to establish job resource synchronization

1 Answers  


NID-00141: No database name specified, previous attempt used string

1 Answers  


ORA-12209: TNS:encountered uninitialized global

1 Answers  






ORA-10580: Can not modify datafile header during test recovery

1 Answers  


DRG-12005: Please give name of file to save in:

1 Answers  


ORA-27200: skgfpgo: sbtpcstart returned error

1 Answers  


ORA-10577: Can not invoke test recovery for managed standby database recovery

1 Answers  


QSM-02041: nested aggregate function

1 Answers  


ORA-24026: operation failed, queue string.string has errors

1 Answers  


ORA-06254: NETNTT: cannot share connection to cube

1 Answers  


Categories