Re: How would you layout the files?
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,
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
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 09 2008 - 03:27:32 CST