設定 STATISTICS_LEVEL = BASIC 會禁用哪些資料庫特性，statisticslevel

設定 STATISTICS_LEVEL = BASIC 會禁用哪些資料庫特性，statisticslevel

設定 STATISTICS_LEVEL = BASIC 會禁用一下oracle 的功能特性

• Automatic Workload Repository (AWR) Snapshots

• Automatic Database Diagnostic Monitor (ADDM)

• All server-generated alerts

• Automatic SGA Memory Management  （ASMM）和自動記憶體管理

• 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