Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OPS insert problem
Hello,
you may try max_commit_propagation_delay.
(i have never used it)
I think it cost performance and may not be practical.
Dependend of your Oracle Version
you should partition your application.
hth
Stefan Kapitza
nronayette_at_alphacsp.com (Nicolas Ronayette) wrote in message news:<8d9a759a.0202180541.1e2ddd61_at_posting.google.com>...
> Hello everybody,
>
> I've got a problem with an OPS on Solaris Cluster.
> Here it is :
>
> With an application Server in front of the OPS (2 instances), i do an
> insert following by a commit, and after this a "select" on the value
> just inserted. I've got something like a "record not found" error. I
> guess that my insert and my select are not on the same instance. How
> can i synchronize the instances more faster to get a quick good answer
> from the other instance ?
>
> I didn't find any post or Oracle documentation/FAQ on this.
>
> I think that, in my configuration, the synchronization is about a
> couple of seconds (when the DBWR write the datas in the datafile or
> something like that).
>
> How can i make it work more quickly ?
>
> Thanks in advance for all your answers.
>
> Nicolas
Received on Mon Feb 18 2002 - 15:46:22 CST