How to determine how long log shipping takes.
edited Nov 3, 2014 11:00AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
11.2.0.4 physical dataguard running on Linux.
Every two days at the same time my dataguard implementation falls behind on log shipping. It always catches up so I'm not too concerned (just need to tweak my monitoring thresholds to avoid the false alerts). I'm assuming that this is caused by network load slowing down the log shipments. I want to figure out how long it takes to ship each log.
I came up with this idea:
select sequence#, first_time, next_time, completion_time,
to_char(completion_time,'yyyymmdd:hh24'),
(round((completion_time - next_time)* 24*60*60)) secs
from v$archived_log
0