Oracle Database - Statistics - STATISTICS_LEVEL parameter
Table of Contents
About
The STATISTICS_LEVEL parameter controls the levels of statistics gathered:
- BASIC: will disables the collection of many of the important statistics
- TYPICAL (Default): will ensure collection of all major statistics required
- ALL: will add timed operating system statistics and plan execution statistics to the TYPICAL level.
Articles Related
Management
Query
You can query it for instance with the show parameter command:
show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- -----------------
statistics_level string TYPICAL
Level
See the view V$STATISTICS_LEVEL for more details.
| ACTIVAT | STATISTICS_NAME | SESSION_ | STATISTICS_VIEW_NAME | DESCRIPTION |
|---|---|---|---|---|
| TYPICAL | Active Session History | ENABLED | V$ACTIVE_SESSION_HISTORY | Monitors active session activity using M |
| Adaptive Thresholds Enabled | ENABLED | Controls if Adaptive Thresholds should b | ||
| Automated Maintenance Tasks | ENABLED | Controls if Automated Maintenance should | ||
| Automatic DBOP Monitoring | ENABLED | V$SQL_MONITOR | Controls if automatic DBOP Monitoring sh | |
| Bind Data Capture | ENABLED | V$SQL_BIND_CAPTURE | Enables capture of bind values used by S | |
| Buffer Cache Advice | ENABLED | V$DB_CACHE_ADVICE | Predicts the impact of different cache s | |
| Global Cache Statistics | ENABLED | RAC Buffer Cache statistics | ||
| Longops Statistics | ENABLED | V$SESSION_LONGOPS | Enables Longops Statistics | |
| MTTR Advice | ENABLED | V$MTTR_TARGET_ADVICE | Predicts the impact of different MTTR se | |
| Modification Monitoring | ENABLED | Enables modification monitoring | ||
| OLAP row load time precision | ENABLED | Sets precision of olap row load time sta | ||
| PGA Advice | ENABLED | V$PGA_TARGET_ADVICE | Predicts the impact of different values | |
| Plan Execution Sampling | ENABLED | V$ACTIVE_SESSION_HISTORY | Enables plan lines sampling | |
| SQL Monitoring | ENABLED | V$SQL_MONITORING | Controls if SQL Monitoring should be ena | |
| Segment Level Statistics | ENABLED | V$SEGSTAT | Enables gathering of segment access stat | |
| Shared Pool Advice | ENABLED | V$SHARED_POOL_ADVICE | Predicts the impact of different values | |
| Streams Pool Advice | ENABLED | V$STREAMS_POOL_ADVICE | Predicts impact on Streams perfomance of | |
| Threshold-based Alerts | ENABLED | Controls if Threshold-based Alerts shoul | ||
| Time Model Events | ENABLED | V$SESS_TIME_MODEL | Enables Statics collection for time even | |
| Timed Statistics | ENABLED | Enables gathering of timed statistics | ||
| Ultrafast Latch Statistics | ENABLED | Maintains statistics for ultrafast latch | ||
| Undo Advisor, Alerts and Fast Ramp up | ENABLED | V$UNDOSTAT | Transaction layer manageability features | |
| V$IOSTAT_* statistics | ENABLED | Controls if I/O stats in v$iostat_ shoul | ||
| ALL | Global Cache CPU Statistics | DISABLED | RAC Buffer Cache CPU statistics | |
| Plan Execution Statistics | DISABLED | V$SQL_PLAN_STATISTICS | Enables collection of plan execution sta | |
| Timed OS Statistics | DISABLED | Enables gathering of timed operating sys |