Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle IO tuning tips/practices on Windows

Re: Oracle IO tuning tips/practices on Windows

From: <bdbafh_at_gmail.com>
Date: 2 Feb 2006 15:18:32 -0800
Message-ID: <1138922312.807196.20760@f14g2000cwb.googlegroups.com>


Have you considered provisioning the RAID volumes in groups of 4 disks as RAID 10, and creating multiple datafiles per tablespace, such that you would have 3 mount points, one per RAID volume (aka LUN).

LUN 0   ID 0,1,2,3
LUN 1   ID 4,5,8,9
LUN 2   ID 10,11,12,13

Create one partition per LUN, for each filesystem blocksize. If all tablespaces have an 8 KB blocksize, one partition per LUN would do, formatted with an 8192 byte blocksize. As you have 2 block sizes, create 2 partitions per LUN, create a second partition per LUN with a 16384 blocksize.

Now you have a setup where the datafile blocks, filesystem and RAID stripes align.

You have increased overhead in terms of having to create sets of datafiles for each tablespace, so its not as simple as your SAME setup.

What you would gain, is that for single block reads, a read request would only have to involve a single drive. This should provide higher concurrency and lower average response time than your existing configuration.

Currently, with a 64 KB stripe size (over 6 disks) and an 8 KB block size, half of the blocks per stripe are divided over multiple hard drives (1,4,5,8 are not). By not aligning the database file blocks and the physical hard drives twice as many physical reads are required half the time to access a single block.

That is a significant penalty.

hth.

-bdbafh Received on Thu Feb 02 2006 - 17:18:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US