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')