DBA_HIST_TABLESPACE_STAT

DBA_HIST_TABLESPACE_STAT displays tablespace information from the control file. This view contains snapshots of V$TABLESPACE and DBA_TABLESPACE.

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
TSNAME VARCHAR2(30)   Tablespace name
CONTENTS VARCHAR2(9)   Tablespace contents:

  • PERMANENT

  • TEMPORARY
STATUS VARCHAR2(9)   Tablespace status:

  • ONLINE

  • OFFLINE

  • READ ONLY
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6)   Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)
EXTENT_MANAGEMENT VARCHAR2(10)   Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL)
IS_BACKUP VARCHAR2(5)   Indicates whether the tablespace is part of a backup