STARTUP ERRORS ora-00824 cannot set sga_target with statistics_level=BASIC
===================================================
This will happen, when your statistics_level parameter is set to BASIC but you define SGA_TARGET in oracle database 10g
SQL> startup
ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information
in alert log you can find this
Cannot set sga_target with statistics_level=BASIC
solution:-
change either one of these value of statistics_level to TYPICAL or SGA_TARGET =0
WWSS
2 days ago
No comments:
Post a Comment