V$TEMP_EXTENT_POOL

Oracle 11gR1

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

Note:

1.

select * from V$TEMP_EXTENT_POOL;

TABLESPACE _NAME	FILE _ID	EXTENTS _CACHED	EXTENTS _USED	BLOCKS _CACHED	BLOCKS _USED	BYTES_CACHED	BYTES_USED	RELATIVE_FNO
TEMP	1	936	0	59904	0	981467136	0	1
TEMP	2	924	0	59136	0	968884224	0	2
TEMP	3	871	0	55744	0	913309696	0	3
TEMP	4	790	0	50560	0	828375040	0	4
TEMP	5	807	106	51648	6784	846200832	111149056	5

Oracle data dictionary views