DBA_HIST_CON_SYSSTAT
DBA_HIST_CON_SYSSTAT displays historical system statistics information, including OLAP kernel statistics. This view contains snapshots of V$CON_SYSSTAT.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
STAT_ID |
NUMBER |
NOT NULL |
Statistic identifier |
STAT_NAME |
VARCHAR2(64) |
NOT NULL |
Statistic name |
VALUE |
NUMBER |
Statistic value | |
CON_DBID |
NUMBER |
NOT NULL |
The database ID for the PDB of the sampled session |
CON_ID |
NUMBER |
NOT NULL |
<p>The ID of the container that CON_DBID identifies. Possible values include: <ul style="list-style-type: disc;"> <li> When queried from a non-CDB, the statistics for that instance are returned, and the CON_ID value is 0. </li> <li> When queried from the root of a CDB, the statistics in every container are returned, and the CON_ID value indicates the container to which the statistics belong. </li> <li> When queried from a PDB, statistics from that PDB are returned, and the CON_ID value is the container ID for that PDB. </li> </ul> </p> |
See Also: