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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

DRG-52102: an invalid transaction handle was passed to Oracle Text

1 Answers  


ORA-00079: variable string not found

1 Answers  


ORA-12072: updatable materialized view log data for "string"."string" cannot be created

1 Answers  


ORA-30365: left relation in the JOIN KEY clause cannot be same as right

1 Answers  


ORA-01865: not a valid era

1 Answers  






LSX-00135: invalid min/max Occurs for <all> element, must be 0/1

1 Answers  


TNS-01157: Can only listen on number addresses - ignoring string

1 Answers  


ORA-39068: invalid master table data in row with PROCESS_ORDER=string

1 Answers  


ORA-31100: XDB Locking Internal Error

1 Answers  


DRG-50851: SQL execute failed

1 Answers  


NNL-00293: Controller's trace level remains unchanged

1 Answers  


TNS-00516: Permission denied

1 Answers  


Categories