Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
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, 105 of 211


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-2001, 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