5.79 DBA_HIST_TEMPFILE
DBA_HIST_TEMPFILE
displays a history of the temp file information from the control file. This view contains snapshots of V$TEMPFILE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Database ID |
|
|
|
File identification number |
|
|
|
Change number at which the temp file was created |
|
|
|
Name of the temp file |
|
|
|
Tablespace number |
|
|
|
Name of the tablespace |
|
|
|
Block size of the temp file |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: