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

PCC-02152: Unable to open file string to display or list the source line number

1 Answers  


PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint

1 Answers  


KUP-04040: file string in string not found

1 Answers  


ORA-13139: could not obtain column definition for string

1 Answers  


ORA-23377: bad name string for missing_rows_oname1 argument

1 Answers  






TNS-01027: Listener Trace File string

1 Answers  


PLS-00495: too many columns in SELECT...INTO statement after bursting record targets

1 Answers  


IMG-00846: adjacency matrix allocation failed

1 Answers  


TNS-00208: Logging : string

1 Answers  


ORA-38434: could not evaluate expression "string"

1 Answers  


ORA-01511: error in renaming log/data files

1 Answers  


RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers  


Categories