select inst_id, -- INST_ID NUMBER applied_scn, -- APPLIED_SCN NUMBER applied_time, -- APPLIED_TIME DATE restart_scn, -- RESTART_SCN NUMBER restart_time, -- RESTART_TIME DATE latest_scn, -- LATEST_SCN NUMBER latest_time, -- LATEST_TIME DATE mining_scn, -- MINING_SCN NUMBER mining_time, -- MINING_TIME DATE resetlogs_id -- RESETLOGS_ID NUMBER from x$krvslvpg