ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
Cause: The user attempted to set statistics_level to BASIC with auto-tune SGA enabled which cannot be done because auto-tune SGA cannot work with statistics_level set to BASIC.
Action: Disable auto-tune SGA and try setting the statistics_level to BASIC again.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00830：无法将statistics_level设置为BASIC，并启用自动调整SGA,
.原因：用户尝试将statistics_level设置为BASIC，并启用了自动调整SGA，因为自动调整SGA无法使用设置为BASIC的statistics_level来工作。,
.操作：禁用自动调整SGA并尝试再次将statistics_level设置为BASIC。,
.

aiaiDBA

13718043309

010-86462881

ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled

1 个回答

相似问题