ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM

Error Message

ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM

Cause

The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.

Action

Set sga_max_size to the recommended value or reduce the values of any SGA component size parameters you have specified.

You May Also Like

Leave a Reply?