Standby Lag Status

We can use view to check Standby Lag delay.

RAC / NON-RAC / Cloud RDS:

SELECT SUM(DECODE(name, 'apply finish time', value, 0)) as Apply_Time, SUM(DECODE(name, 'apply lag', value, 0)) as Apply_LAG, SUM(DECODE(name, 'transport lag', value, 0)) as Transport_LAG from (SELECT name, extract(day from p.val) *86400 + extract(hour from p.val) *3600 + extract(minute from p.val) *60 + extract(second from p.val) value from (SELECT name,to_dsinterval(value) val from v$dataguard_stats) p );