Skip to main content

DBA_LOGSTDBY_LOG and DBA_LOGSTDBY_PROGRESS

using DBA_LOGSTDBY_LOG and DBA_LOGSTDBY_PROGRESS views sql apply process can be monitored

SELECT L.SEQUENCE#, L.FIRST_TIME, (CASE WHEN L.NEXT_CHANGE# < P.READ_SCN THEN 'YES'WHEN L.FIRST_CHANGE# < P.APPLIED_SCN THEN 'CURRENT' ELSE 'NO' END) APPLIED FROM DBA_LOGSTDBY_LOG L, DBA_LOGSTDBY_PROGRESS P ORDER BY SEQUENCE#;

Comments

Popular posts from this blog