Re: How would you layout the files?
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- Date: Tue, 09 Dec 2008 20:27:32 +1100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
