VIEW: SYS.DBA_HIST_SEG_STAT

Source

View Text - Preformatted

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 INT$DBA_HIST_SEG_STAT

View Text - HTML Formatted

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 INT$DBA_HIST_SEG_STAT