Database Reference
In-Depth Information
STATISTICS_LEVEL
This parameter sets the amount of statistics that will be collected. This parameter could be set to one of these three
values:
BASIC
,
TYPICAL
, or
ALL
.
TYPICAL
is the default; when Oracle enables or sets the value to
TYPICAL
or
ALL
, it
automatically enables the
STATISTICS_LEVEL
parameter.
Setting the
STATISTICS_LEVEL
to
ALL
will enable the collection of O/S-level statistics. This should be done only
under controlled conditions because it could degrade performance to a great extent.
V$STATISTICS_LEVEL
The
V$STATISTICS_LEVEL
view provides the status of the statistics or advisories controlled by the
STATISTICS_LEVEL
initialization parameter. Most of the advice views will provide statistical advice when the
STATISTICS_LEVEL
is set to
TYPICAL
or
ALL
:
COL NAME FORMAT A38
SELECT statistics_name NAME,
session_status ses_status,
system_status sys_status,
activation_level alevel,
session_settable sestable
FROM v$statistics_level
/
NAME SES_STAT SYS_STAT ALEVEL SES
-------------------------------------- -------- -------- ------- ---
Buffer Cache Advice ENABLED ENABLED TYPICAL NO
MTTR Advice ENABLED ENABLED TYPICAL NO
Timed Statistics ENABLED ENABLED TYPICAL YES
Timed OS Statistics DISABLED DISABLED ALL YES
Segment Level Statistics ENABLED ENABLED TYPICAL NO
PGA Advice ENABLED ENABLED TYPICAL NO
Plan Execution Statistics DISABLED DISABLED ALL YES
Shared Pool Advice ENABLED ENABLED TYPICAL NO
Modification Monitoring ENABLED ENABLED TYPICAL NO
Longops Statistics ENABLED ENABLED TYPICAL NO
Bind Data Capture ENABLED ENABLED TYPICAL NO
Ultrafast Latch Statistics ENABLED ENABLED TYPICAL NO
Threshold-based Alerts ENABLED ENABLED TYPICAL NO
Global Cache Statistics ENABLED ENABLED TYPICAL NO
Global Cache CPU Statistics DISABLED DISABLED ALL NO
Active Session History ENABLED ENABLED TYPICAL NO
Undo Advisor, Alerts and Fast Ramp up ENABLED ENABLED TYPICAL NO
Streams Pool Advice ENABLED ENABLED TYPICAL NO
Time Model Events ENABLED ENABLED TYPICAL YES
Plan Execution Sampling ENABLED ENABLED TYPICAL YES
Automated Maintenance Tasks ENABLED ENABLED TYPICAL NO
Automatic DBOP Monitoring ENABLED ENABLED TYPICAL YES
SQL Monitoring ENABLED ENABLED TYPICAL YES
Adaptive Thresholds Enabled ENABLED ENABLED TYPICAL NO
V$IOSTAT_* statistics ENABLED ENABLED TYPICAL NO
OLAP row load time precision ENABLED ENABLED TYPICAL YES
Search WWH ::
Custom Search