Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 103 of 237


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.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback