This view displays the state of temporary space cached and used for a given instance. Note that loading of the temporary space cache is lazy, and that instances can be dormant. Use GV$TEMP_EXTENT_POOL for information about all instances.
| Column | Datatype | Description |
|---|---|---|
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace |
FILE_ID |
NUMBER |
Absolute file number |
EXTENTS_CACHED |
NUMBER |
How many extents have been cached |
EXTENTS_USED |
NUMBER |
How many extents are actually being used |
BLOCKS_CACHED |
NUMBER |
How many blocks are cached |
BLOCKS_USED |
NUMBER |
How many blocks are used |
BYTES_CACHED |
NUMBER |
How many bytes are cached |
BYTES_USED |
NUMBER |
How many bytes used |
RELATIVE_FNO |
NUMBER |
The relative file number |