Dynamic Performance (V$) Views, 168 of 179

V$TEMP_EXTENT_MAP

This view displays the status of each unit for all temporary tablespaces.

Column Datatype Description

TABLESPACE_NAME

NUMBER

Name of tablespace this unit belongs to

FILE_ID

NUMBER

Absolute file number

BLOCK_ID

NUMBER

Begin block number for this unit

BYTES

NUMBER

Bytes in extent

BLOCKS

NUMBER

Blocks in extent

OWNER

NUMBER

Which instance own this unit (string)

RELATIVE_FNO

NUMBER

The relative file number

Column	Datatype	Description
`TABLESPACE_NAME`	`NUMBER`	Name of tablespace this unit belongs to
`FILE_ID`	`NUMBER`	Absolute file number
`BLOCK_ID`	`NUMBER`	Begin block number for this unit
`BYTES`	`NUMBER`	Bytes in extent
`BLOCKS`	`NUMBER`	Blocks in extent
`OWNER`	`NUMBER`	Which instance own this unit (string)
`RELATIVE_FNO`	`NUMBER`	The relative file number