DBA_HIST_SEG_STAT

DBA_HIST_SEG_STAT displays historical information about segment-level statistics. This view captures the top segments based on a set of criteria and captures information from V$SEGSTAT. The total value is the value of the statistics since instance startup. The delta value is the value of the statistics from the BEGIN_INTERVAL_TIME to the END_INTERVAL_TIME in the DBA_HIST_SNAPSHOT view.

Column	Datatype	Description
`SNAP_ID`	`NUMBER`	Unique snapshot ID
`DBID`	`NUMBER`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	Instance number for the snapshot
`TS#`	`NUMBER`	Tablespace number
`OBJ#`	`NUMBER`	Dictionary object number
`DATAOBJ#`	`NUMBER`	Data object number
`LOGICAL_READS_TOTAL`	`NUMBER`	Cumulative value for logical reads
`LOGICAL_READS_DELTA`	`NUMBER`	Delta value for logical reads
`BUFFER_BUSY_WAITS_TOTAL`	`NUMBER`	Cumulative value for buffer busy waits
`BUFFER_BUSY_WAITS_DELTA`	`NUMBER`	Delta value for buffer busy waits
`DB_BLOCK_CHANGES_TOTAL`	`NUMBER`	Cumulative value for db block changes
`DB_BLOCK_CHANGES_DELTA`	`NUMBER`	Delta value for db block changes
`PHYSICAL_READS_TOTAL`	`NUMBER`	Cumulative value for physical reads
`PHYSICAL_READS_DELTA`	`NUMBER`	Delta value for physical reads
`PHYSICAL_WRITES_TOTAL`	`NUMBER`	Cumulative value for physical writes
`PHYSICAL_WRITES_DELTA`	`NUMBER`	Delta value for physical writes
`PHYSICAL_READS_DIRECT_TOTAL`	`NUMBER`	Cumulative value for physical reads direct
`PHYSICAL_READS_DIRECT_DELTA`	`NUMBER`	Delta value for physical reads direct
`PHYSICAL_WRITES_DIRECT_TOTAL`	`NUMBER`	Cumulative value for physical writes direct
`PHYSICAL_WRITES_DIRECT_DELTA`	`NUMBER`	Delta value for physical writes direct
`ITL_WAITS_TOTAL`	`NUMBER`	Cumulative value for ITL waits
`ITL_WAITS_DELTA`	`NUMBER`	Delta value for ITL waits
`ROW_LOCK_WAITS_TOTAL`	`NUMBER`	Cumulative value for row lock waits
`ROW_LOCK_WAITS_DELTA`	`NUMBER`	Delta value for row lock waits
`GC_CR_BLOCKS_SERVED_TOTAL`	`NUMBER`	Cumulative value for global cache CR blocks served
`GC_CR_BLOCKS_SERVED_DELTA`	`NUMBER`	Delta value for global cache CR blocks served
`GC_CU_BLOCKS_SERVED_TOTAL`	`NUMBER`	Cumulative value for global cache current blocks served
`GC_CU_BLOCKS_SERVED_DELTA`	`NUMBER`	Delta value for global cache current blocks served
`GC_BUFFER_BUSY_TOTAL`	`NUMBER`	Cumulative value for global cache buffer busy
`GC_BUFFER_BUSY_DELTA`	`NUMBER`	Delta value for global cache buffer busy
`GC_CR_BLOCKS_RECEIVED_TOTAL`	`NUMBER`	Cumulative value for global cache CR blocks received
`GC_CR_BLOCKS_RECEIVED_DELTA`	`NUMBER`	Delta value for global cache CR blocks received
`GC_CU_BLOCKS_RECEIVED_TOTAL`	`NUMBER`	Cumulative value for global cache current blocks received
`GC_CU_BLOCKS_RECEIVED_DELTA`	`NUMBER`	Delta value for global cache current blocks received
`SPACE_USED_TOTAL`	`NUMBER`	Cumulative value for space used
`SPACE_USED_DELTA`	`NUMBER`	Delta value for space used
`SPACE_ALLOCATED_TOTAL`	`NUMBER`	Cumulative value for space allocated
`SPACE_ALLOCATED_DELTA`	`NUMBER`	Delta value for space allocated
`TABLE_SCANS_TOTAL`	`NUMBER`	Cumulative value for table scans
`TABLE_SCANS_DELTA`	`NUMBER`	Delta value for table scans