select
  START_DATE,                              -- START_DATE DATE
  REQUIRED_START_DATE,                     -- REQUIRED_START_DATE DATE
  END_DATE,                                -- END_DATE DATE
  START_SCN,                               -- START_SCN NUMBER
  REQUIRED_START_SCN,                      -- REQUIRED_START_SCN NUMBER
  END_SCN,                                 -- END_SCN NUMBER
  OPTIONS,                                 -- OPTIONS NUMBER
  INFO,                                    -- INFO VARCHAR2(32)
  STATUS                                   -- STATUS NUMBER
from
  GV$LOGMNR_PARAMETERS
where
  inst_id = userenv('instance')