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

CLSR-01002: Unable to process instance startup

2 Answers  


ORA-38602: FI invalid input cursor

1 Answers  


ORA-14510: can specify VALIDATE INTO clause only for partitioned tables

1 Answers  


ORA-25126: Invalid name specified for BUFFER_POOL

1 Answers  


ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

1 Answers  






ORA-12351: cannot create view using a remote object which has a remote object reference

1 Answers  


NCR-03019: NCRO: Unable to initialize thread support

1 Answers  


DRG-11108: invalid filename specified: string

1 Answers  


ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

1 Answers  


ORA-31424: change table has active subscriptions

1 Answers  


EXP-00030: Unexpected End-Of-File encountered while reading input

1 Answers  


PLS-00670: sort columns must be simple column names

1 Answers  


Categories