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

Error Message

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.

You May Also Like

Leave a Reply?