Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: OCF(v2).

Re: OCF(v2).

From: DA Morgan <>
Date: Mon, 05 Nov 2007 18:55:14 -0800
Message-ID: <> wrote:
> On Nov 5, 6:32 pm, DA Morgan <> wrote:

>> wrote:
>>> Hi,
>>> I need some advise from someone who knows alot about OCF and maybe CFs
>>> in general..
>>> Suppose you have two independent (A & B) database nodes share a
>>> database volume on a CF.
>>> Is it possible to have the CF queue (FIFO) requests (read / write)
>>> from either node in order to let them be executed in that order?
>>> Rgds
>>> /PL
>> Please define your terms.
>> 1. What version of Oracle?
>> 2. Are you discussing RAC? If not what are you discussing?
>> 3. If RAC have you read the concepts and architecture docs?
>>     Which ones?

> Thanks for your reply.
> 10g, two stand alone DBs (not RAC) + proprietary cluster.
>> If you want serialization what you are saying is that if node 1
>> starts something that will take 15 minutes you want node 2 to
>> freeze. Does this make sense?

> Well, that's a good to begin with but if that's the starting point we
> would like to add nifty features such as.
> i) If a write process has been active for more than x seconds, pass
> through all read processes in the queue.
> And with even more intelligence added: ii) Write's could be passed
> through as well as long as they don't interfere with each other.
> Rgds
> /PL

Addendum. When one of your instances locks a table or offlines a tablespace what do you think is going to happen? When one instance using a SCN and the other instance uses a different SCN at the same time what do you expect is going to happen?

I expect the consultant that is hired to clean up this mess will be buying a new boat next spring. Reconsider what you are doing.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Nov 05 2007 - 20:55:14 CST

Original text of this message