Re: NT/ORACLE/RAID and Performance PAIN

>You didn't mention you filesystem type?(NTFS or FAT).

|| oops! NTFS.
>
>I would load the Oracle Perfmon extentions.

|| diskperf? Done.

>
>If you are being constrained to RAID5 by none dba's then I would explain
>the overhead in using RAID5. This usually sways them.

|| No. As usual, by system and $$ people who bought spindles without

    considering RAID 0+1. <sigh>

>
>I would monitor the disk queues to illustrate the bottleneck on the disk
>controller.

|| How to do this, exactly? Should I be concerned about APCs and DPCs.

>
>To bump the performance on NT you can disable any unrequired services

|| done.

>and set the Control_Panel->Network->Services->Server property to
>'Maximize performance for Network Apps' (This will reduce the amount of
>memory allocated to the disk cache, which Oracle doesn't use)

|| I *think* this is done, but I will ask the NT box guy....

>
>Check the sql statements that are being executed, might be worth looking
>at SQLab www.quests.com.

|| I am building tspaces and running import. ( yes, without indexes and constraints in place)

    For performance tuning, I really like "Q" by Savant Corporation. Free downloads at

    www.savant-corp.com

|| Thanks for your help with this......... Received on Mon Feb 15 1999 - 15:48:48 CST