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

  • December 29, 2017 | 15 views
  • Comments