Re: OCF(v2).

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Nov 2007 18:55:14 -0800
Message-ID: <1194317710.314595@bubbleator.drizzle.com>

per.lanvin_at_fouredge.se wrote:
> On Nov 5, 6:32 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> per.lan..._at_fouredge.se 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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Nov 05 2007 - 20:55:14 CST