Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Warehouse on Windows

Re: Data Warehouse on Windows

From: Thomas Day <tday6_at_csc.com>
Date: Thu, 15 Aug 2002 07:03:32 -0800
Message-ID: <F001.004B6096.20020815070332@fatcity.com>

RAID 0+1. Hardware mirroring. Pentium III, two CPUs and 1G of RAM. And a sysadmin who can set up the RAID (the contracting officer will break my hands if I touch hardware other than the keyboard). Get dual controllers if you can so you can do some worthwhile separating of redo logs and rollback segments. Probably it will be a Dell or a Gateway. Don't bother with a monitor bigger than 15". For some reason management figures that a high price computer needs a large monitor (probably some sort of Freudian envy at work there) but this is going to be a server that will sit off in a quiet corner with no one sitting at the keyboard. No sound board, no speakers, no fancy video board.

                                                                                                                   
                    "Sackwitz,                                                                                     
                    Antje"               To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <Antje.Sackwi        cc:                                                                       
                    tz                   Subject:     Data Warehouse on Windows                                    
                    @ppi.de>                                                                                       
                    Sent by: root                                                                                  
                                                                                                                   
                                                                                                                   
                    08/15/2002                                                                                     
                    09:58 AM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   




Hi,
I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users <20. Probably long running queries.
Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision.
Any tips/recommendations appreciated
Antje Sackwitz

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sackwitz, Antje
  INET: Antje.Sackwitz_at_ppi.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: tday6_at_csc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
Received on Thu Aug 15 2002 - 10:03:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US