Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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.



Action:


Set sga_target 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.