DBA_HIST_TABLESPACE_STAT
displays tablespace information from the control file. This view contains snapshots of V$TABLESPACE
and DBA_TABLESPACES
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Tablespace number |
|
|
Tablespace name |
|
|
|
Tablespace contents:
|
|
|
|
Tablespace status:
|
|
|
|
Indicates whether the free and used segment space in the tablespace is managed using free lists ( |
|
|
|
Indicates whether the extents in the tablespace are dictionary managed ( |
|
|
|
Indicates whether the tablespace is part of a backup |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: