Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$TEMP_EXTENT_MAP

This view displays the status of each unit for all LOCALLY MANAGED 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