Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-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
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

V$LOGMNR_DICTIONARY_LOAD

V$LOGMNR_DICTIONARY_LOAD displays information about LogMiner dictionaries for all active LogMiner sessions on the system. Each query of this view will return one row for each attached LogMiner session. This view will not show valid information for LogMiner adhoc query clients.

Column Datatype Description
SESSION_ID NUMBER LogMiner session ID
LOGMNR_UID NUMBER LogMiner dictionary UID
ACTION# NUMBER Reserved for internal use
OPCODE NUMBER Reserved for internal use
COMMAND VARCHAR2(161) Current command being executed
CURRENT_STATE VARCHAR2(32) Summary information if LOADED=ACTIVE
COMPLETED_ACTIONS NUMBER The steps completed so far
TOTAL_ACTIONS NUMBER Total steps to complete
LOADED VARCHAR2(7) Status of the dictionary load:
  • YES - dictionary has been loaded

  • NO - dictionary has not been loaded

  • ACTIVE - dictionary is in the process of being loaded

PERCENT_DONE NUMBER Percentage of the dictionary that has been loaded