apply_lag.sql

set feedback 1
set linesize 120
column name format a12
column lag_time format a20
column datum_time format a20
column time_computed format a20
SELECT NAME,substr((SUBSTR(VALUE,5)),0,2)*3600 + substr((SUBSTR(VALUE,5)),4,2)*60 + substr((SUBSTR(VALUE,5)),7,2) AS seconds, VALUE LAG_TIME, DATUM_TIME,
 TIME_COMPUTED from V$DATAGUARD_STATS where name like 'apply lag';