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-21603: property id [string] is invalid

1 Answers  


TNS-12681: Login failed: the SecurID card does not have a pincode yet

1 Answers  


ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.

1 Answers  


QSM-01008: no query rewrite for update queries

1 Answers  


ORA-23606: invalid object string

1 Answers  


ORA-12828: Can't start parallel transaction at a remote site

1 Answers  


RMAN-08156: printing stored script: string

1 Answers  


ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred

1 Answers  


PLS-00144: duplicate external CALLING STANDARD specification in subprogram expression

1 Answers  


TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX

1 Answers  


ORA-01882: timezone region string not found

1 Answers  


PLS-00409: duplicate variable 'string' in INTO list is not permitted

1 Answers  


Categories