10G Replicaton schedule push frequency/timing
I am upgrading a system from Oracle 8i to 10g. My 8i replication system pushes my deferred transactions every 3 seconds. When I schedule the 10g replication push job for every 3 seconds , the job is executed about every 5 seconds. I tried setting the interval to 1 second and get the same results.
The system is idle most of the time, only a few transactions are ever propagated by the push job.
During the test below, there were no transactions to push.
My job is clearly schedule once every 3 seconds:
select dblink, interval, last_date, next_date From defschedule
DBLINK JOB
----------------------------------------------------------- ------