DBA_HIST_CON

4.309 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`	The ID of the container that `CON_DBID` identifies. Possible values include: When queried from a non-CDB, the statistics for that instance are returned, and the `CON_ID` value is `0`. 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. When queried from a PDB, statistics from that PDB are returned, and the `CON_ID` value is the container ID for that PDB.