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

This view contains information about redo log files.

Column Datatype Description

GROUP#

NUMBER

Redo log group identifier number

STATUS

VARCHAR2(7)

Status of the log member:

  • INVALID - File is inaccessible
  • STALE - File's contents are incomplete
  • DELETED - File is no longer used
  • blank - File is in use

TYPE

VARCHAR2(7)

MEMBER

VARCHAR2(513)

Redo log member name