Re: How would you layout the files?

Greg Rahn wrote,on my timestamp of 9/12/2008 9:35 AM:

SAME - stripe and mirror everything.

Redo and Data should be fine together.  In fact, with only 4 spindles
available for the db, I wouldn't have it any other way.  RAID-10 the 4
drives and mount it up as a single volume.  Pray for the best.



I'd almost go with this one.  With one "but":
Create more than one "volume", in fact as many as you have
"groups" of storage in the database: redos, undos, temps,
data.
And assign each to a drive letter in Windows.

One of the things that most people forget is that Windows
has one I/O queue per disk drive letter.  You overload
a single drive letter queue with all the I/O requests
of the db and I can virtually guarantee a slow I/O performance.
Windows does not react very well to very large disk request
queues.
DAMHIKT...



--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: