Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

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

Dynamic Performance (V$) Views, 89 of 179


V$LOGMNR_DICTIONARY

This view contains log history information.

Column  Datatype  Description 

TIMESTAMP 

DATE 

The date the dictionary was created 

DB_ID 

NUMBER 

The database ID 

DB_NAME 

VARCHAR2(8) 

The name of the database 

FILENAME 

VARCHAR2(513) 

The dictionary filename 

DICTIONARY_SCN 

NUMBER 

The system change number when the dictionary was created 

RESET_SCN 

NUMBER 

The reset log SCN when the dictionary was created 

RESET_SCN_TIME 

NUMBER 

The 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-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index