How to fix the error ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings?

In this post, you’ll learn more about the Oracle ErrorORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings

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.

How to fix the Error ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings ?

You can fix this error in Oracle by following the below steps

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.