Determining Transport lag
edited Sep 1, 2009 5:42AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered
Hi,
We are using oracle grid control to determine the dataguard transport lag. But but looks like the SQL used by the agent is fetching wrong results.
AGENT SQL
-------------------
We are using oracle grid control to determine the dataguard transport lag. But but looks like the SQL used by the agent is fetching wrong results.
AGENT SQL
-------------------
SELECT SUM(DECODE(name, 'apply finish time', value, 0)) FOT, SUM(DECODE(name, 'apply lag', value, 0)) LAG, SUM(DECODE(name, 'transport lag', value, 0)) PDL 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 );
<br/>
<br/>
FOT LAG PDLWhereas the following query gives totally different results.
---------- ---------- ----------
46755.6 87449 261
0