Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why dbms_defer_sys.schedule_push with updateable snapshots
Jake wrote:
>>afaik, the push job pushed out deferred transactions (i.e. >>transactions not cascaded to all snapshots), the purge job >>purges transaction/data records from the master tables, only >>for those transactions that have been propagated to all >>registered snapshots. >>If you picture refresh on demand, the mechanism, and the need >>for it, becomes obvious. >> >>Grtz, Frank >>
Correct. What if I just got back from holidays, and logged into
the network the first time since 2 weeks? All those transactions
would still be waiting for me. Nevertheless, if the replication
on demand fails, there's a job scheduled to make sure it's attempted
over and over again.
Normally, this job will have no work.
Received on Sun Jan 12 2003 - 07:45:52 CST