[Home] [Help] [Dependency Information]
Object Name: | V_$LOGMNR_LOGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | |||
FILENAME | VARCHAR2 | (512) | ||
LOW_TIME | DATE | |||
HIGH_TIME | DATE | |||
DB_ID | NUMBER | |||
DB_NAME | VARCHAR2 | (8) | ||
RESET_SCN | NUMBER | |||
RESET_SCN_TIME | DATE | |||
COMPATIBLE | VARCHAR2 | (17) | ||
THREAD_ID | NUMBER | |||
THREAD_SQN | NUMBER | |||
LOW_SCN | NUMBER | |||
NEXT_SCN | NUMBER | |||
DICTIONARY_BEGIN | VARCHAR2 | (3) | ||
DICTIONARY_END | VARCHAR2 | (3) | ||
TYPE | VARCHAR2 | (7) | ||
BLOCKSIZE | NUMBER | |||
FILESIZE | NUMBER | |||
INFO | VARCHAR2 | (32) | ||
STATUS | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_ID
, FILENAME
, LOW_TIME
, HIGH_TIME
, DB_ID
, DB_NAME
, RESET_SCN
, RESET_SCN_TIME
, COMPATIBLE
, THREAD_ID
, THREAD_SQN
, LOW_SCN
, NEXT_SCN
, DICTIONARY_BEGIN
, DICTIONARY_END
, TYPE
, BLOCKSIZE
, FILESIZE
, INFO
, STATUS
, CON_ID
FROM SYS.V_$LOGMNR_LOGS;
|
|
|