GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

10G Replicaton schedule push frequency/timing

edited Feb 17, 2010 10:12PM in GoldenGate, Streams and Distributed Database (MOSC) 8 commentsAnswered

  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

-----------------------------------------------------------  ------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center