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

This view contains log history information.

Column Datatype Description

TIMESTAMP

DATE

Date the dictionary was created

DB_ID

NUMBER

Database ID

DB_NAME

VARCHAR2(8)

Name of the database

FILENAME

VARCHAR2(513)

Dictionary filename

DICTIONARY_SCN

NUMBER

System change number when the dictionary was created

RESET_SCN

NUMBER

Reset log SCN when the dictionary was created

RESET_SCN_TIME

DATE

Time when the reset log SCN was obtained to create the dictionary

ENABLED_THREAD_MAP

RAW(16)

Bit map of currently enabled threads when the dictionary was created

INFO

VARCHAR2(32)

Informational/Status message BAD_DATE indicates that the SCN of the dictionary file does not match the SCN range of the log files

STATUS

NUMBER

A NULL indicates a valid dictionary file for the list of log files. A non-NULL value indicates further information is contained in the INFO column as a text string.