[Home] [Help] [Dependency Information]
Object Name: | DBA_HIST_SEG_STAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Historical Statistics Information
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
TS# | NUMBER | Yes | ||
OBJ# | NUMBER | Yes | ||
DATAOBJ# | NUMBER | Yes | ||
LOGICAL_READS_TOTAL | NUMBER | |||
LOGICAL_READS_DELTA | NUMBER | |||
BUFFER_BUSY_WAITS_TOTAL | NUMBER | |||
BUFFER_BUSY_WAITS_DELTA | NUMBER | |||
DB_BLOCK_CHANGES_TOTAL | NUMBER | |||
DB_BLOCK_CHANGES_DELTA | NUMBER | |||
PHYSICAL_READS_TOTAL | NUMBER | |||
PHYSICAL_READS_DELTA | NUMBER | |||
PHYSICAL_WRITES_TOTAL | NUMBER | |||
PHYSICAL_WRITES_DELTA | NUMBER | |||
PHYSICAL_READS_DIRECT_TOTAL | NUMBER | |||
PHYSICAL_READS_DIRECT_DELTA | NUMBER | |||
PHYSICAL_WRITES_DIRECT_TOTAL | NUMBER | |||
PHYSICAL_WRITES_DIRECT_DELTA | NUMBER | |||
ITL_WAITS_TOTAL | NUMBER | |||
ITL_WAITS_DELTA | NUMBER | |||
ROW_LOCK_WAITS_TOTAL | NUMBER | |||
ROW_LOCK_WAITS_DELTA | NUMBER | |||
GC_CR_BLOCKS_SERVED_TOTAL | NUMBER | |||
GC_CR_BLOCKS_SERVED_DELTA | NUMBER | |||
GC_CU_BLOCKS_SERVED_TOTAL | NUMBER | |||
GC_CU_BLOCKS_SERVED_DELTA | NUMBER | |||
GC_BUFFER_BUSY_TOTAL | NUMBER | |||
GC_BUFFER_BUSY_DELTA | NUMBER | |||
GC_CR_BLOCKS_RECEIVED_TOTAL | NUMBER | |||
GC_CR_BLOCKS_RECEIVED_DELTA | NUMBER | |||
GC_CU_BLOCKS_RECEIVED_TOTAL | NUMBER | |||
GC_CU_BLOCKS_RECEIVED_DELTA | NUMBER | |||
SPACE_USED_TOTAL | NUMBER | |||
SPACE_USED_DELTA | NUMBER | |||
SPACE_ALLOCATED_TOTAL | NUMBER | |||
SPACE_ALLOCATED_DELTA | NUMBER | |||
TABLE_SCANS_TOTAL | NUMBER | |||
TABLE_SCANS_DELTA | NUMBER | |||
CHAIN_ROW_EXCESS_TOTAL | NUMBER | |||
CHAIN_ROW_EXCESS_DELTA | NUMBER | |||
PHYSICAL_READ_REQUESTS_TOTAL | NUMBER | |||
PHYSICAL_READ_REQUESTS_DELTA | NUMBER | |||
PHYSICAL_WRITE_REQUESTS_TOTAL | NUMBER | |||
PHYSICAL_WRITE_REQUESTS_DELTA | NUMBER | |||
OPTIMIZED_PHYSICAL_READS_TOTAL | NUMBER | |||
OPTIMIZED_PHYSICAL_READS_DELTA | NUMBER | |||
CON_DBID | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, TS#
, OBJ#
, DATAOBJ#
, LOGICAL_READS_TOTAL
, LOGICAL_READS_DELTA
, BUFFER_BUSY_WAITS_TOTAL
, BUFFER_BUSY_WAITS_DELTA
, DB_BLOCK_CHANGES_TOTAL
, DB_BLOCK_CHANGES_DELTA
, PHYSICAL_READS_TOTAL
, PHYSICAL_READS_DELTA
, PHYSICAL_WRITES_TOTAL
, PHYSICAL_WRITES_DELTA
, PHYSICAL_READS_DIRECT_TOTAL
, PHYSICAL_READS_DIRECT_DELTA
, PHYSICAL_WRITES_DIRECT_TOTAL
, PHYSICAL_WRITES_DIRECT_DELTA
, ITL_WAITS_TOTAL
, ITL_WAITS_DELTA
, ROW_LOCK_WAITS_TOTAL
, ROW_LOCK_WAITS_DELTA
, GC_CR_BLOCKS_SERVED_TOTAL
, GC_CR_BLOCKS_SERVED_DELTA
, GC_CU_BLOCKS_SERVED_TOTAL
, GC_CU_BLOCKS_SERVED_DELTA
, GC_BUFFER_BUSY_TOTAL
, GC_BUFFER_BUSY_DELTA
, GC_CR_BLOCKS_RECEIVED_TOTAL
, GC_CR_BLOCKS_RECEIVED_DELTA
, GC_CU_BLOCKS_RECEIVED_TOTAL
, GC_CU_BLOCKS_RECEIVED_DELTA
, SPACE_USED_TOTAL
, SPACE_USED_DELTA
, SPACE_ALLOCATED_TOTAL
, SPACE_ALLOCATED_DELTA
, TABLE_SCANS_TOTAL
, TABLE_SCANS_DELTA
, CHAIN_ROW_EXCESS_TOTAL
, CHAIN_ROW_EXCESS_DELTA
, PHYSICAL_READ_REQUESTS_TOTAL
, PHYSICAL_READ_REQUESTS_DELTA
, PHYSICAL_WRITE_REQUESTS_TOTAL
, PHYSICAL_WRITE_REQUESTS_DELTA
, OPTIMIZED_PHYSICAL_READS_TOTAL
, OPTIMIZED_PHYSICAL_READS_DELTA
, CON_DBID
, CON_ID
FROM SYS.DBA_HIST_SEG_STAT;
|
|
|