oracle表空间历史情况,如何监控表空间的历史增长记录？

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

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

10g,这个字典监控的东西很到位.