看看延时超过几秒钟(更精细)
- --如果超过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;