aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

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.

请先 登录 后评论

1 个回答

小智
ORA-00821:sga_target 字符串的指定值太小,需要至少为字符串 M,
.原因: sga_target的指定值太小,SGA无法容纳所有必需的SGA组件,例如日志缓冲区,缓冲池,共享池等。,
.操作:将sga_target设置为建议值或减小您指定的任何SGA组件大小参数的值。,
.
请先 登录 后评论