Oracle Solution for Error ora-00821

Solution for Oracle Error ORA-00821

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

What triggered the Error:

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

What should we do to fix it:

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