Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-38484: FUNCTION/PACKAGE/TYPE string does not exist

1 Answers  


ORA-24074: RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string

1 Answers  


ORA-24000: invalid value string, string should be of the form [SCHEMA.]NAME

1 Answers  


LPX-00278: invalid ~s proxy "~s"

1 Answers  


PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)

1 Answers  






ORA-12628: TNS:no event callbacks

1 Answers  


ORA-07552: sftget: $GET failure

1 Answers  


ORA-40208: duplicate or multiple algorithm settings for function string

1 Answers  


ORA-16780: Destination to some database has used up its quota.

1 Answers  


PLS-00354: username must be a simple identifier

1 Answers  


ORA-23334: column string does not exist in table or column group

1 Answers  


LSX-00287: duplicate key "~S"

1 Answers  






Categories