Re:Drive Configuration

From: <dgoulet_at_vicr.com>
Date: Thu, 25 Jan 2001 10:25:17 -0500
Message-Id: <10752.127489@fatcity.com>

Woody,

    Depends. Are you using a disk array? If so is there more than one path
(equate that to interface cables) to the disks. If yes then your right, there
wrong & will pay the price.

    If on the other hand there is one and only one path to the drives, it really doesn't matter. Everything has to go down that path & that is where the bottle neck will be.

Dick Goulet

____________________Reply Separator____________________

Subject: Drive Configuration
Author: "Woody Mckay" <wmckay_at_hydrogenmedia.com> Date: 1/25/2001 7:01 AM

I was asked by some hardware people of my suggested drive configuration for a 5 drive configuration.

I recommended the following:

Drive 1 - Oracle database software
Drive 2 - System tablespace, control file_1, online redo log files
Drive 3 - Roll back (RBS) tablespace, Temp tablespace, control file_2
Drive 4 - Data tablespace, control file_3
Drive 5 - Index tablespace, archived log files

I thought this would optimize the performance of small transactions and small queries. I also thought it would optimize I/O performance by distributing the tablespaces. The database is for a Cold Fusion web site where there will be mostly reads but plenty of writes.

They disregarded this configuration and decided to go with a raid-5 with everything on the single raid for recoverability. I caved in and said ok. Were they right?

Sincerely,

Woody

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Woody Mckay
  INET: wmckay_at_hydrogenmedia.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 Jan 25 2001 - 09:25:17 CST