-----
-- View: V$LOGSTDBY_PROGRESS
-- Purpose: Determines which SCNs have already been applied via Logical Apply Services
-----
TTITLE 'Logical Apply Services Progress|(from V$LOGSTDBY_PROGRESS)'
COL applied_scn FORMAT 999999999 HEADING 'Redo|Applied|Thru|SCN'
COL applied_dtm FORMAT A12 HEADING 'Redo Applied|Thru Time'
COL restart_scn FORMAT 999999999 HEADING 'Apply|Restart|SCN'
COL restart_dtm FORMAT A12 HEADING 'Apply|Restart|Time'
COL latest_scn FORMAT 999999999 HEADING 'Latest|Redo|SCN'
COL latest_dtm FORMAT A12 HEADING 'Latest Redo|Applied At'
COL mining_scn FORMAT 999999999 HEADING 'Latest|Redo|Built|SCN'
COL mining_dtm FORMAT A12 HEADING 'Latest Redo|Built Thru'
SELECT
applied_scn
,TO_CHAR(applied_time,'yyyy-mm-dd hh24:mi:ss') applied_dtm
,restart_scn
,TO_CHAR(restart_time,'yyyy-mm-dd hh24:mi:ss') restart_dtm
,latest_scn
,TO_CHAR(latest_time,'yyyy-mm-dd hh24:mi:ss') latest_dtm
,mining_scn
,TO_CHAR(mining_time,'yyyy-mm-dd hh24:mi:ss') mining_dtm
FROM v$logstdby_progress
;