监控dg延时多少秒

看看延时超过几秒钟（更精细）

--如果超过120秒则告警
select *
  from (select sysdate,
               sum(apply_finish) apply_finish,
               sum(apply_lag) apply_lag,
               sum(transport_lag) transport_lag,
               sum(startup_time) startup_time,
               min(TIME_COMPUTED) TIME_COMPUTED
          from (select decode(name,
                              'apply finish time',
                              to_number(substr(value, 2, 2)) * 86400 +
                              to_number(substr(value, 5, 2)) * 3600 +
                              to_number(substr(value, 8, 2)) * 60 +
                              to_number(substr(value, 11, 2)),
                              0) apply_finish,
                       decode(name,
                              'apply lag',
                              to_number(substr(value, 2, 2)) * 86400 +
                              to_number(substr(value, 5, 2)) * 3600 +
                              to_number(substr(value, 8, 2)) * 60 +
                              to_number(substr(value, 11, 2)),
                              0) apply_lag,
                       decode(name,
                              'transport lag',
                              to_number(substr(value, 2, 2)) * 86400 +
                              to_number(substr(value, 5, 2)) * 3600 +
                              to_number(substr(value, 8, 2)) * 60 +
                              to_number(substr(value, 11, 2)),
                              0) transport_lag,
                       decode(name, 'estimated startup time', value, 0) startup_time,
                       TIME_COMPUTED
                  from v$dataguard_stats
                 where name in ('apply finish time',
                                'apply lag',
                                'estimated startup time',
                                'transport lag')))
 where apply_lag > 120;