Dynamic Performance (V$) Views, 169 of 179

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

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