RECID: This is the archived log record ID.
STAMP: This is the archived log record
NAME: This is the archived log file name.
If set to NULL, the log file was cleared before it was archived.
STATUS: This is the status of the archived
log. It can have the following values: A – Available; D –
Deleted; U – Unavailable; and X – Expired.
COMPLETION_TIME_DATE: This is the time when
the archiving for this log is completed.
DICTIONARY_BEING: This indicates whether
the log contains the start of a LogMiner dictionary or not.
DICTIONARY_END: This indicates whether the
log contains the end of a LogMiner dictionary or not.
FIRST_CHANGE#: This is the first
change# in the archived log.
FIRST_TIME DATE: This is the timestamp of
the first change.
NEXT_CHANGE#: This is the first
change in the next log.
NEXT_TIME DATE: This is the timestamp of
the next change.
BLOCKS: This is the size of the
archived log, in blocks.
BLOCK_SIZE: This is the redo log
block size. This is the logical block size of the archived log,
which is the same as the logical block size of the online log
from which the archived log was copied. The online log logical
block size is a platform-specific value that is not adjustable
by the user.
This view displays information about the
registered archived logfiles in the database for the Capture
processes which are the consumers of the log files.