Re: Oracle IO tuning tips/practices on Windows

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: 3 Feb 2006 04:32:38 -0800
Message-ID: <1138969958.568282.124040@z14g2000cwz.googlegroups.com>

NetComrade wrote:
> On 1 Feb 2006 16:22:27 -0800, "Noons" <wizofoz2k_at_yahoo.com.au> wrote:
>
> >NetComrade wrote:
> >> Can anyone point to a useful resource on tuning IO for Oracle on
> >> Windows?
> >
> >Nial Litchfield was puting together a compilation of resources
> >for tuning Oracle on Windows. Perhaps you can swing around
> >his website and ask?
> >http://www.orawin.info/services/index.php
>
> Nial needs to tune her blog software a bit :)
> Thanks for the link

And indeed get some more Windows specific content :). If there was a specific issue that you have drop me a line privately and I'll have a look at it. The software and hosting provider I'm using is very new to me.

> >> I've never dealt with Oracle on Windows before, but someone asked to
> >> help them out with IO performance problems (they can get the dell
> >> powervault SCSI disk array to push data to about 80Megs/sec at the
> >> (same) time when Oracle is only pushing about 20M/sec)

How are they measuring the Oracle specific IO throughput?

> >Check that the Oracle datafiles are in dedicated disk partition(s)
> >that does not have any other Windows-related files in it.
>
> The db is on the array, OS on local disks
>
> >Check that these partition(s) was/were created and formatted with a
> >sector
> >size that matches the database block size (8K?).
>
> That's why i needed some Ora/Win resource, I have no idea how to check
> those things on Windows.

fsutil from the Windows Server Resource kit (this is this laptop)

C:\Program Files\Windows Resource Kits\Tools>fsutil fsinfo ntfsinfo c:

NTFS Volume Serial Number :       0xee80613680610705
Version :                         3.1
Number Sectors :                  0x0000000004a813ff
Total Clusters :                  0x000000000095027f
Free Clusters  :                  0x00000000001ec232
Total Reserved :                  0x0000000000000000
Bytes Per Sector  :               512
Bytes Per Cluster :               4096

Bytes Per FileRecord Segment : 1024
Clusters Per FileRecord Segment : 0

Mft Valid Data Length :           0x000000000cf9c000
Mft Start Lcn  :                  0x00000000000c0000
Mft2 Start Lcn :                  0x0000000000000010
Mft Zone Start :                  0x00000000008dfe20
Mft Zone End   :                  0x00000000008fd4c0

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/ Received on Fri Feb 03 2006 - 06:32:38 CST