Oracle DBA, How To, Error, Cause and Action

▼

ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET


Cause:


STATISTICS_LEVEL of BASIC was incompatible with SGA_TARGET and MEMORY_TARGET.



Action:


Fix the incompatible parameter setting. Set STATISTICS_LEVEL to TYPICAL or ALL to use SGA_TARGET or MEMORY_TARGET.

No comments:

Post a Comment

Thanks for your comment.