Oracle DBA, How To, Error, Cause and Action

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

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.

No comments:

Post a Comment

Thanks for your comment.