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 |
For internal use only |
OPCODE |
NUMBER |
For internal use only |
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:
|
PERCENT_DONE |
NUMBER |
Percentage of the dictionary that has been loaded |