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: Tue, 06 Nov 2007 07:55:29 -0800
Message-ID: <> wrote:

> On Nov 6, 3:53 am, DA Morgan <> wrote:
>> 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
>> Two separate 10g instances hitting the same database files without
>> the benefit of Oracle clusterware? Have you considered just dropping
>> a brick on your foot. Why? My expectation is that you are trying to
>> earn pain and will likely get a boatload of it.
> ((:
> Well, it's not easy but if the concept can be proven the idea has alot
> of potential.
> Rgds
> /PL

The brick takes less time and anyone that has studied Oracle RAC can predict, with 99.99999999% certainty, the outcome.

It is one thing to waste time reinventing the wheel.

Quite another to think throwing yourself off a cliff is a good way to learn to fly.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Nov 06 2007 - 09:55:29 CST

Original text of this message