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