select
  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
  gv$logstdby_progress
where
  inst_id = USERENV('Instance')