Apply Lag-Active Dataguard
Hi Gurus, 11203 RAC RHEL 6.1
I have a RAC active dataguard setup with RAC primary(3 -node).There is a Lag of few seconds goes upto 10 mins which is unacceptable for real time reporting.I need to fix the apply lag so that the lag is 0 secs.I have securefile LOBS(XMLTYPE) in the db and network encryption enabled.
Please let me know how to tune the apply lag.
Dataguard_stats:
transport lag | day(2) to second(0) interval | 01/12/2015 10:22:41 | ||
apply lag | +00 00:00:08 | day(2) to second(0) interval | 01/12/2015 10:22:41 | 01/12/2015 10:22:40 |
apply finish time | day(2) to second(3) interval | 01/12/2015 10:22:41 | ||
estimated startup time | 52 | second | 01/12/2015 10:22:41 |
MRP wait event:
class slave wait | 0 | 2 |
class slave wait |