RE: Oracle 9.2 RAC on Win2K?

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 25 Jun 2003 11:33:20 -0700
Message-ID: <F001.005B98AC.20030625111014@fatcity.com>

On the PULSE side, we are running 8i but on the DW side, we're running 9.2.
>From my experience, 9.2 doesn't need that much of an application
partitioning
as 8i. I mentioned "PULSE" because you also worked for Oxford as a consultant
so you know what application system I'm talking about.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]

-----Original Message-----
Sent: Wednesday, June 25, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L

At Oxford you are running Oracle8i, correct? Do you believe that application partitioning is as important with 9i and cache fusion as it is in 8i?

• Mladen Gogala <[EMAIL PROTECTED]> wrote:
  >
  > > Has anyone seen/run/stumbled over similar beast, if so - does it
  > "fly"
  > > or it "stinks"?
  >
  > Depends on the application system. RAC is a bit more tolerant, but
  > you still
  > want to minimize the block exchange between the nodes. Application
  > system must
  > be "functionally partitioned", meaning that related data should be
  > accessed
  > from the same node. Example: let's imagine that we have health care
  > application system which has elements like members/groups/providers,
  > claims
  > and drug utilization/ 3rd party vendors. Each of the listed groups is
  > a
  > complex application system accessing several hundreds of related
  > tables. Good
  > thing would be to put each of the listed application groups on its
  > own node
  > with the 4th node reserved for batch processing. If block exchange is
  > frequent
  > and DLM has a lot of work to do, then "flying" means "free falling
  > until you
  > hit the ground".
  

> > P.S.
> >
> > I've looked at number of metalink articles and found none yet to
> > "scratch" this specific "itch" of mine.
> >
> > Oracle RAC on Win2K is for some bizarre reason REQUIREMENT.
>
> Requirement by who? It usually helps to make a business case for a
> specific
> configuration and benchmark it to see whether the performance is
> satisfactory.
> Let me suggest a little benchmark: 4 clustered, beefed up PC boxes
> vs. a
> single, 16-CPU IBM P690 with the latest "960" CPUs and AIX 5.2. You
> can
> benchmark price and performance. I'd be very intrigued to find out
> the
> outcome. It is very hard to predict it properly (wink, wink).
>
>
> >
> >
>
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

---

Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED]

---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 25 2003 - 13:33:20 CDT