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

Part Number E25513-03
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
PDF · Mobi · ePub
REFRN30378

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

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF