DBA_HIST_TEMPFILE displays a history of the tempfile information from the control file. This view contains snapshots of V$TEMPFILE.
| Column | Datatype | NULL | Description |
|---|---|---|---|
DBID |
NUMBER |
NOT NULL |
Database ID |
FILE# |
NUMBER |
NOT NULL |
File identification number |
CREATION_CHANGE# |
NUMBER |
NOT NULL |
Change number at which the tempfile was created |
FILENAME |
VARCHAR2(513) |
NOT NULL |
Name of the tempfile |
TS# |
NUMBER |
NOT NULL |
Tablespace number |
TSNAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace |
BLOCK_SIZE |
NUMBER |
Block size of the tempfile |