V$TEMP_EXTENT_POOL

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