5.51 DBA_HIST_SESSMETRIC_HISTORY
DBA_HIST_SESSMETRIC_HISTORY
displays the history of several important session metrics.
Note:
This view is populated only if a session metric exceeds a server metric threshold that was configured using the DBMS_SERVER_ALERT
package.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Begin time of the interval |
|
|
|
End time of the interval |
|
|
|
Session ID |
|
|
|
Session serial number |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
Group ID |
|
|
|
Metric ID |
|
|
|
Metric name |
|
|
|
Metric Value |
|
|
|
Unit of measurement |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also:
The DBMS_SERVER_ALERT
package in Oracle Database PL/SQL Packages and Types Reference