Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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 NULL 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