Dynamic Performance (V$) Views, 171 of 179

V$TEMP_SPACE_HEADER

This view displays aggregate information per file per temporary tablespace regarding how much space is currently being used and how much is free as per the space header.

Column Datatype Description

TABLESPACE_NAME

VARCHAR2(30)

The name of the temporary tablespace

FILE_ID

NUMBER

The absolute file number

BYTES_USED

NUMBER

How many bytes are in use

BLOCKS_USED

NUMBER

How many blocks are in use

BYTES_FREE

NUMBER

How many bytes are free

BLOCKS_FREE

NUMBER

How many blocks are free

RELATIVE_FNO

NUMBER

The relative file number for the file

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	The name of the temporary tablespace
`FILE_ID`	`NUMBER`	The absolute file number
`BYTES_USED`	`NUMBER`	How many bytes are in use
`BLOCKS_USED`	`NUMBER`	How many blocks are in use
`BYTES_FREE`	`NUMBER`	How many bytes are free
`BLOCKS_FREE`	`NUMBER`	How many blocks are free
`RELATIVE_FNO`	`NUMBER`	The relative file number for the file