Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.