OPS insert problem

From: Nicolas Ronayette <nronayette_at_alphacsp.com>
Date: 18 Feb 2002 05:41:30 -0800
Message-ID: <8d9a759a.0202180541.1e2ddd61@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 - 07:41:30 CST