Oracle-L: Re: Oracle Server / W2K

From: <Jared.Still_at_radisys.com>
Date: Wed, 02 Apr 2003 09:44:29 -0800
Message-ID: <F001.005784BE.20030402094429@fatcity.com>

Joshua,

The correct answer is: it depends.

It depends on how fast the response time from the database needs to be.

It depends on how much data you have.

If your database and archive logs and everything else your app needs will never be more than 48 Gig, then you may want to create 3 mirrored drives so that you can shuffle files around if necessary.

It could be that your app would work just fine on a 48 gig RAID 10, in which
case you just put everything on on logical volume.

Maybe you need 70 gig, in which case the only choice you have is to put all 6 drives in a RAID5 group.

Jared

Joshua Becker <jbecker_sweden_at_yahoo.se>
Sent by: root_at_fatcity.com
04/01/2003 11:13 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Oracle Server / W2K

Hi all,

what might be the best configuration for OLTP database if you have following "components":

DL380 2*1.4ghz, 2GB Mem, 6*16GB 15k Disks...

And what is the correct flag for Optimize Performance for Applications or Background Processes...

TIA
Joshua

Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express Se mer på: http://se.docs.yahoo.com/info/express/help/index.html
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: =?iso-8859-1?q?Joshua=20Becker?= INET: jbecker_sweden_at_yahoo.se

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------