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$TEMPFILE

This view displays tempfile information.

Column Datatype Description

FILE#

NUMBER

The absolute file number

CREATION_CHANGE#

NUMBER

The creation System Change Number (SCN)

CREATION_TIME

DATE

The creation time

TS#

NUMBER

The tablespace number

RFILE#

NUMBER

The relative file number in tablespace

STATUS

VARCHAR2(7)

The status of the file (OFFLINE|ONLINE)

ENABLED

VARCHAR2(10)

Enabled for read and/or write

BYTES

NUMBER

The size of the file in bytes (from file header)

BLOCKS

NUMBER

The size of the file in blocks (from file header)

CREATE_BYTES

NUMBER

The creation size of the file (in bytes)

BLOCK_SIZE

NUMBER

The block size for the file

NAME

VARCHAR2(513)

The name of the file