How to fix the error ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM?

In this post, you’ll learn more about the Oracle ErrorORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM ?

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

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