DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, December 29, 2017

ORA-00824 cannot set sga_target with statistics_level=BASIC

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

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