Find Oracle Error Code Ora- and Pl/SQL Tips and Tricks

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.

Popularity: 4% [?]

Share This

Related Post

• ORA-00832: no streams pool created and cannot automatically create one
• ORA-01002: fetch out of sequence
• ORA-01001 : invalid cursor
• ORA-01000 : maximum open cursors exceeded
• ORA-00999 : invalid view name
• ORA-00998 : must name this expression with a column alias
• ORA-00997 : illegal use of LONG datatype
• ORA-00996 : the concatenate operator is ||, not |
• ORA-00995 : missing or invalid synonym identifier
• ORA-00994 : missing OPTION keyword