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-12810: PARALLEL_MAX_SERVERS must be less than or equal to string

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


ORA-31659: status message was invalid type - detaching job

1 Answers  


ORA-37012: (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.

1 Answers  


ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function

1 Answers  


IMG-00911: free basic data structure failed

1 Answers  


NZE-28866: Invalid peer certificate encoding

1 Answers  


TNS-00295: Navigator: Security is enabled, you cannot STOP the Navigator

1 Answers  


SQL*Loader-00514: Error getting elapsed time

1 Answers  


ORA-39098: Worker process received data objects while loading metadata. Invalid process order range is string..string

1 Answers  


ORA-04022: nowait requested, but had to wait to lock dictionary object

2 Answers   Oracle,


LSX-00290: invalid enumeration choice "~S"

1 Answers  


Categories