RE: Q. To RAC or go vertical

RAC - Intel is not yet proven as far as I can tell. So be very cautious about choosing this path for such a large project.  

I would probably stick with the big box and concentrate on as fast as IO as possible. No wait please do the RAC with Intel quads, figure out all the bugs and pitfalls and then let us know so we can avoid them... :)  

(We are in the process now of getting a lab setup with RAC and Intel to do some testing.)  

Brad O.    

-----Original Message-----
Sent: Tuesday, August 05, 2003 7:30 AM
To: Multiple recipients of list ORACLE-L

Hi All

I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu)

Background

Txn - OLTP like txn during day but batch extracts at night and

        very big batch extract periodically Data Volume - 5-10 TByte
Data volatility - 99 % of data is very much like a ware house (unchanged)

                other 1% is read/update/delete/insert

Options
1. Say a very large server like a HP Superdome or SUN E12000

        with 8 CPUs
        Server already exist so cost is in obtaining additional CPU/Blades
        ie Traditional Server using plain old vanilla Oracle EE


        - can still increase head room.  

        - batch programs can utilise all 8 CPUs

        - storage system need not cater for clustering


2,  Same large server like a HP Superdome or SUN E12000 but partitioned
        into two. Each with 4 CPU.
        Oracle RDBMS + RAC option


        - storage server need to cater for cluster config

        - max performance for batch is with 4 CPUs only

Which would you prefer and why. I am not convinced with the RAC option. Now
if I was going with cheaper Intel servers like Dell servers with 4 CPUS each, and
purchase say 4 nodes of 4 cpus each, that would be a different story. In this case
I have the equipment and ability to grow vertically.

ta
tony

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.com

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: ListGuru_at_fatcity.com (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).