null values in v$dataguard_stats
edited Jan 15, 2016 10:05AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 19 commentsAnswered
Hi,
The below query is returning null values in the standby and because of this we are unable to monitor lag in standby
SELECT SUM(DECODE(name, 'apply finish time', value, null)) FOT, SUM(DECODE(name, 'apply lag', value, null)) LAG,
SUM(DECODE(name, 'transport lag', value, null)) PDL
2 3 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
4 from (SELECT name,to_dsinterval(value) val from v$dataguard_stats) p);
FOT LAG PDL
---------- ---------- ----------
Best regards,
Vishal
0