[Home] [Help] [Dependency Information]
Object Name: | V_$LOGMNR_LOGFILE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | |||
FILENAME | VARCHAR2 | (513) | ||
LOW_TIME | NUMBER | |||
NEXT_TIME | NUMBER | |||
DB_ID | NUMBER | |||
DB_NAME | VARCHAR2 | (8) | ||
RESET_SCNWRP | NUMBER | |||
RESET_SCNBAS | NUMBER | |||
RESET_SCN_TIME | NUMBER | |||
THREAD_ID | NUMBER | |||
THREAD_SQN | NUMBER | |||
LOW_SCNWRP | NUMBER | |||
LOW_SCNBAS | NUMBER | |||
NEXT_SCNWRP | NUMBER | |||
NEXT_SCNBAS | NUMBER | |||
FILE_STATE | VARCHAR2 | (13) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_ID
, FILENAME
, LOW_TIME
, NEXT_TIME
, DB_ID
, DB_NAME
, RESET_SCNWRP
, RESET_SCNBAS
, RESET_SCN_TIME
, THREAD_ID
, THREAD_SQN
, LOW_SCNWRP
, LOW_SCNBAS
, NEXT_SCNWRP
, NEXT_SCNBAS
, FILE_STATE
, CON_ID
FROM SYS.V_$LOGMNR_LOGFILE;
|
|
|