Oracle-L: Re[2]: Data Warehouse on Windows

From: <dgoulet_at_vicr.com>
Date: Thu, 15 Aug 2002 15:29:12 -0800
Message-ID: <F001.004B719E.20020815152912@fatcity.com>

Well, there are options Jared. If your using a system that has 4 or fewer CPU's you could license standard edition which does not have all of the bells and whistles of Enterprise. That though would constrain a datawarehouse somewhat, but at $15K per processor it is cheaper. Now if you can absolutely tell Oracle who the users are and don't have a web server or other transaction processor in between the users and the data then you can go for a user based license. BUT you've got to license 5 users per processor minimum which as was said with < 20 users that's a good 4 CPU box. User licenses are $300 per on Standard and $800 per on Enterprise. Breaking out the old calculator yields a price tag of $16K for a 4 processor box with 20 users on Enterprise edition. Not too bad. But watch out for the maintenance too, that adds $3,520 to the purchase price & is an annual bill.

Just make sure that whoever buys the server buys it with all of the memory(ram) it will hold.

Dick Goulet

____________________Reply Separator____________________
Author: Jared.Still_at_radisys.com
Date:       8/15/2002 2:51 PM

Antje,

Before you determine the number CPU's, you need to talk to your Oracle rep about your proposed DW and determine how they will make you license it.

If you're not already under some kind of license that covers existing users on a new system, Oracle will likely tell you that you need to license per CPU.

If that's the case, you might consider going with the fastest CPU's you can get, and limiting it to 2 CPU's. With that number of users and a fairly small DW, you would most likely be fine.

Of course, I don't know anything about your requirements, but I do know that an EE license is $40k U.S. per CPU, which can really eat into the budget for a small project.

HTH Jared

"Sackwitz, Antje" <Antje.Sackwitz_at_ppi.de> Sent by: root_at_fatcity.com
08/15/2002 06:58 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Data Warehouse on Windows

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:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------