8.77 V$METRIC
V$METRIC
displays the most recent statistic values for the complete set of metrics captured by the Automatic Workload Repository (AWR) infrastructure.
Column | Datatype | Description |
---|---|---|
|
|
Begin time of the interval |
|
|
End time of the interval |
|
|
Interval size (in hundredths of a second) |
|
|
Metric Group ID. Refer to the |
|
|
Entity ID for the metric in question. The value of the Entity ID depends upon the metric group. (See the following table for an explanation of possible values.) |
|
|
Entity Sequence number for the metric in question. The value of the Entity Sequence depends upon the metric group. (See the following table for an explanation of possible values.) |
|
|
Metric ID |
|
|
Metric Name. This is the statistic that is captured for the entity. |
|
|
Value of the statistic between |
|
|
Unit for the |
|
|
The ID of the container to which the data pertains. Possible values include:
|
The following table describes what the ENTITY_ID
and ENTITY_SEQUENCE
are for each metric group:
GID | Group NAME | Entity ID | Entity Sequence |
---|---|---|---|
0 |
Event Metrics |
Event# |
N/A |
1 |
Event Class Metrics |
Wait Class ID |
N/A |
2 |
System Metrics Long Duration |
N/A |
N/A |
3 |
System Metrics Short Duration |
N/A |
N/A |
4 |
Session Metrics Long Duration |
Session ID |
Serial# |
5 |
Session Metrics Short Duration |
Session ID |
Serial# |
6 |
Service Metrics |
N/A |
Service Hash |
7 |
File Metrics Long Duration |
File# |
Creation Change# |
9 |
Tablespace Metrics Long Duration |
Tablespace# |
N/A |
10 |
Service Metrics (Short) |
N/A |
Service Hash |