Re: Oracle IO tuning tips/practices on Windows

Answers embedded:
"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:nom4u1hajl4hc9579kcj60bfhhv1iv7m6q_at_4ax.com...
> On 1 Feb 2006 17:12:30 -0800, bdbafh_at_gmail.com wrote:
>
> The array is Dell PowerVault V220. There is a 128M cache.. more
> details below

It would be better with 256M or even more

>>db_block_size
> 8K and 16K
>>number of SCSI RAID controllers and channels
> 1 and 1 (I think)
>>number of hard drives
> 12
>>RAID configuration (e.g. 8 disk RAID 10)
> 12 disk RAID10 (6disk stripe)
>>stripe size (e.g. 256 KB stripe)
> 64K

Better would be 256KB or even 1MB
(Your drives are doing seek operations most of the time!)

>>An 8 drive RAID 10 volume of stripe size 256 KB would be a good start.
>>with an 8192 byte db block size, a db_file_multiblock_read_count = 32
>>would read a full stripe. That doesn't help much with single block io,
>>unless the blocks are prefetched and accessed before they are aged out.
>
> Their db_file_multiblock_read_count is set to 8. Which is fine for an

But 32 would be better after larger (256MK) stripe set

Jack Received on Mon Feb 06 2006 - 02:40:39 CST