Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: I really don't get it: Asynchronous replication every 2 seconds
Yes, you can do it. In test environments I've done it every 10 seconds (10/86400). You're burning up a lot of cpu and io for this - seems like there are better ways. What are you trying to accomplish? Jim
"Sander" <sorry_at_no.mail.back.com> wrote in message
news:39a06244.2555210_at_news.a2000.nl...
> Hi Sybrand,
>
> The problem is that I did not design it, I only have to implement it.
> It has to be asynchronous. No synchrone, no standby.
>
> I have been wondering if it is possible to have asynchronous
> replication every 2 a 3 seconds, because Oracle polls only once a
> minute.
>
> thanks,
> Sander
>
> >You're really asking too much.
> >If you would set the interval to 2 seconds, the only thing your server
would
> >do is replicate. Once a minute is already placing a burden on the system.
> >For what purpose do you replicate?
> >If you do this to maintain a live backup copyh, you should use the hot
> >standby option.
>
>
> >> I'm trying to configure (using oracle replication manager) 2 databases
> >> to replicate every 2 seconds.
> >> It replicates twice a minute, and not 30 times a minute ?
> >> even I have said: interval 2 seconds.
> >> Can someone explain me step by step how to configure asynchronous
> >> replication or give me some tips, etc.
> >> Another question, if you modify something in the configuration, how
> >> fast will the modifications be modified by the Oracle server.
> >> Immediatelly, or do you have to wait a minute, 10 minutes, ... Can you
> >> test immediatelly or do you have to wait for a while.
>
Received on Mon Aug 21 2000 - 23:12:06 CDT