Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors:
SQL> startup ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing
internalsettings,seealertlog for moreinformation Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit. You issue this command and get errors:
SQL> startup ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing
internalsettings,seealertlog for moreinformation Why did the instance fail to start?

A.
because sga_target and memory_target are both set

B.
because pga_aggregate_target is not set

C.
because statistics_level is set to basic

D.
because memory_target and memory_max_target cannot be equal

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

yogui

yogui

C

Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:

Automatic Workload Repository (AWR) Snapshots
Automatic Database Diagnostic Monitor (ADDM)
All server-generated alerts
Automatic SGA Memory Management

Reply