|
THREAD#
|
NUMBER
|
NOT NULL
|
Thread ID of the archived redo log. The THREAD number is 1 for a single instance. For Oracle9i Real Application Clusters, this column will contain different numbers.
|
|
SEQUENCE#
|
NUMBER
|
NOT NULL
|
Sequence number of the archived redo log file
|
|
FIRST_CHANGE#
|
NUMBER
|
|
SCN of the current archived redo log
|
|
NEXT_CHANGE#
|
NUMBER
|
|
SCN of the next archived redo log
|
|
FIRST_TIME
|
DATE
|
|
Date of the current archived redo log
|
|
NEXT_TIME
|
DATE
|
|
Date of the next archived redo log
|
|
FILE_NAME
|
VARCHAR2(513)
|
|
Name of the archived redo log
|
|
TIMESTAMP
|
DATE
|
|
Time when the archived redo log was registered
|
|
DICT_BEGIN
|
VARCHAR2(3)
|
|
(YES/NO) Indicates whether the beginning of the dictionary build is in this particular archived redo log
|
|
DICT_END
|
VARCHAR2(3)
|
|
(YES/NO) Indicates whether the end of the dictionary build is in this particular archived redo log
|
