Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

Identify three types of important statistics collection that you can disable in Oracle Database 12c
by setting the STATISTIS_LEVEL parameter to BASIC.

Identify three types of important statistics collection that you can disable in Oracle Database 12c
by setting the STATISTIS_LEVEL parameter to BASIC.

A.
Oracle Database alert.log file

B.
object-level statistics

C.
Automatic SGA Memory Management

D.
Oracle Database Trace files

E.
all server-generated alerts

Show Hint

Leave a Reply 1

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

Prateek

Prateek

Answer :BCE

Explanation :
https://docs.oracle.com/database/121/REFRN/refrn10214.htm#REFRN10214

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
• 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

Reply