Optimum I/O setup for control files.

Hi all,

This has probably been beaten to death in a FAQ somewheres, but I can't seem to find it.

For an 8.1.7 DB on Solaris8, I think I've got my file placement down except for the control files. As far as drives left unoccupied, I've got 2+2
(four) 36GB 10K (15K, maybe?) SCSIs. All 4 drives are in the same physical
box, but each 2 sets of drives has separate controllers and power.

So, considering performance and reliability, where do I put the control file or files? Here are the options as I see it:

1. Stripe each set of 2 drives. Have Oracle put a CF on each.
2. Mirror each drive from set A onto a drive on set B. Have Oracle put a CF on each.
3. Stripe set A, mirror onto set B. Have Oracle put 1 CF on the set. -or-

If I bring in the 6-way stripe (mirrored to another 6-way) we're using for the datafiles:

4) Stripe set A, mirror onto set B. Have Oracle put 1 CF on this set, and another on the 6-way.
5) Stripe all 4 together (no mirror). Have Oracle put 1 CF on this set, and another on the 6-way.

Of course, I'm limiting this to only 2 CFs -- that's not set in stone, but with all the mirroring going on between all these controllers and power supplies, I didn't see a need to triple the CF count. Also, I have no idea what kind of load this DB will take. It'll be driven by a vendor's product, and I don't know how big the DB is yet (but I have to create it!), how many will hit it concurrently, etc. <sigh>

Any advice is welcome. Thanks! :)

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).