Re: sun solaris / oracle tuning ideas

Sybrand Bakker wrote:

> I guess that is 1 single RAID-5 array?
> Make sure the online redolog files and the controlfiles are *not* located on
> RAID-5. This is an ultimate bottleneck for any Oracle database, let alone
> for a dot com.
> Other than that this is of course a way to broad question. Books have been
> written about the interaction between Unix and Oracle.
> You may want to check
> James Morle Scaling Oracle 8i.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>

I'll add to this that you should make sure that your online redo logs are large enough so that they are not switching rapidly. I try to aim for at least a 10 minute interval under average load. The reason for this is that every time a redo log switch occurs you will also get a checkpoint and there is a lot of overhead involved in a checkpoint. Also, make sure that you have at least 4 online redo logs so that you'll never encounter an instance where the redo log switch cannot occur because archiving has not been completed on the next log file to be used.

Beyond that, consider adding another disk array and start striping the database usage across both arrays to reduce head contention.

BTW, a 20% wio level isn't all that bad - especially considering that sar may not be very accurate in a multi-processor environment. Received on Fri Dec 01 2000 - 08:42:49 CST