Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index