V$TEMP_EXTENT_POOL

V$TEMP_EXTENT_POOL displays the state of temporary space cached and used for the instance. Note that loading of the temporary space cache is lazy and that instances can be dormant.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the tablespace
`FILE_ID`	`NUMBER`	Absolute file number
`EXTENTS_CACHED`	`NUMBER`	Number of extents that have been cached
`EXTENTS_USED`	`NUMBER`	Number of extents that are actually being used
`BLOCKS_CACHED`	`NUMBER`	Number of blocks that are cached
`BLOCKS_USED`	`NUMBER`	Number of blocks that are used
`BYTES_CACHED`	`NUMBER`	Number of bytes that are cached
`BYTES_USED`	`NUMBER`	Number of bytes that are used
`RELATIVE_FNO`	`NUMBER`	Relative file number