V$TEMP_EXTENT_MAP

Oracle 11gR1

V$TEMP_EXTENT_MAP displays the status of each unit for all LOCALLY MANAGED temporary tablespaces.

Column	Datatype	Description
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace this unit belongs to
FILE_ID	NUMBER	Absolute file number
BLOCK_ID	NUMBER	Begin block number for this unit
BYTES	NUMBER	Bytes in the extent
BLOCKS	NUMBER	Blocks in the extent
OWNER	NUMBER	Instance which owns this unit
RELATIVE_FNO	NUMBER	Relative file number

Note:

1.

select * from V$TEMP_EXTENT_MAP;

TABLESPACE_NAME	FILE_ID	BLOCK_ID	BYTES	BLOCKS	OWNER	RELATIVE_FNO
TEMP	8	5	1048576	64	1	8
TEMP	8	69	1048576	64	1	8
TEMP	8	133	1048576	64	1	8
TEMP	8	197	1048576	64	1	8

Oracle data dictionary views