Oracle 12c Ocp-1

To implement Automatic Memory Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:

SQL > Startup

Ora-00824:cannot set Sga_target or memory_target due to existing internal settings, see Alert Log for more information.

Identify The reason the instance failed to start.

A. The Pga_aggregate_target parameter is set to zero.

B. The Statistics_level parameter is set to BASIC.

C. Both the Sga_target and Memory_target parameters are set.

D. The sga_max_size and Sga_target parameter values is not equal.

Statistics_level Property

	Description
parameter type	string
syntax	statistics_level = {All | Typical | BASIC}
Default value	TYPICAL
Modifiable	ALTER SESSION,ALTER SYSTEM

statistics_level  specifies The level of collection for database and operating system STATISTICS. The Oracle Database collects these statistics for a variety of purposes, including making self-management decisions.

setting the statistics_level  parameter to basic  disables The collection of many of the important statistics required by Oracle Database features and Fu Nctionality, including:

• Automatic Workload Repository (AWR) snapshots

• Automatic Database Diagnostic Monitor (ADDM)

• All server-generated Alerts

• Automatic SGA Memory Management

• Automatic Optimizer Statistics Collection

• Object Level Statistics

• end to End Application tracing (v$client_stats )

• Database Time Distribution statistics ( V$SESS_TIME_MODEL and V$SYS_TIME_MODEL )

• Service Level Statistics

• Buffer Cache Advisory

• MTTR Advisory

• Shared Pool Sizing Advisory

• Segment Level Statistics

• PGA Target Advisory

• Timed Statistics

• Monitoring of statistics

When theSTATISTICS_LEVELparameter is modified byALTER SYSTEM, all advisories or statistics is dynamically turned on or off, depending on the new value ofSTATISTICS_LEVEL. When modified byALTER SESSION, the following advisories or statistics is turned on or off in the local session only. Their system-wide state was not changed:

• timed statistics

• timed OS Statistics

• plan Execution Statistics

Oracle 12c Ocp-1