View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE). When you tried to start
Posted: Wed Jun 07, 2023 6:11 am
View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE). When you tried to start the database instance, you received the following error:SQL> startup -ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more informationWhy did the instance fail to start?Exhibit:
A. Because the PGA_AGGREGATE_TARGET parameter is not set
B. Because the STATISTICS_LEVEL parameter is set to BASIC
C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
A. Because the PGA_AGGREGATE_TARGET parameter is not set
B. Because the STATISTICS_LEVEL parameter is set to BASIC
C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.