V$LOGMNR_LOGS definition in Oracle Database 11.2
V$LOGMNR_LOGS

select
  LOG_ID,                                  -- LOG_ID NUMBER
  FILENAME,                                -- FILENAME VARCHAR2(512)
  LOW_TIME,                                -- LOW_TIME DATE
  HIGH_TIME,                               -- HIGH_TIME DATE
  DB_ID,                                   -- DB_ID NUMBER
  DB_NAME,                                 -- DB_NAME VARCHAR2(8)
  RESET_SCN,                               -- RESET_SCN NUMBER
  RESET_SCN_TIME,                          -- RESET_SCN_TIME DATE
  COMPATIBLE,                              -- COMPATIBLE VARCHAR2(17)
  THREAD_ID,                               -- THREAD_ID NUMBER
  THREAD_SQN,                              -- THREAD_SQN NUMBER
  LOW_SCN,                                 -- LOW_SCN NUMBER
  NEXT_SCN,                                -- NEXT_SCN NUMBER
  DICTIONARY_BEGIN,                        -- DICTIONARY_BEGIN VARCHAR2(3)
  DICTIONARY_END,                          -- DICTIONARY_END VARCHAR2(3)
  TYPE,                                    -- TYPE VARCHAR2(7)
  BLOCKSIZE,                               -- BLOCKSIZE NUMBER
  FILESIZE,                                -- FILESIZE NUMBER
  INFO,                                    -- INFO VARCHAR2(32)
  STATUS                                   -- STATUS NUMBER
from
  GV$LOGMNR_LOGS
where
  inst_id = userenv('instance')

home |  up