Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Check Tuning" script available for download.....
Btw, this script works for ORACLE on ANY platform, not just NT.
Regards,
--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm
David Sisk wrote in message ...
>Please see the site below for download. I've added a "Check Tuning" script
>that provides a "quick view" of instance-level performance. The script
>selects dynamic performance statistics, performs calculations, determines
if
>the value is within a suggested target range, and suggests initialization
>parms or configuration changes to implement or further investigate. It's
>essentially equivalent to several hundred pages of tuning documentation,
all
>rolled up a in script. Areas examined include:
>
>- Library cache hit ratio
>- Dictionary cache hit ratio
>- Buffer cache hit ratio
>- Sort area hit ratio
>- Redo log space requests
>- Enqueue waits
>- Checkpoint degradation
>- Rollback contention
>- Redo allocation latch contention (willing-to-wait and immediate latches)
>- Redo copy latch contention (willing-to-wait and immediate latches)
>- Freelist contention
>
>Try it, and email me any comments, criticisms, or areas you'd like to see
>added!
>
>Thanks and regards,
>
>--
>David C. Sisk
>The Unofficial ORACLE on NT site
>http://www.ipass.net/~davesisk/oont.htm
>
>
>
>
Received on Fri Dec 11 1998 - 22:36:59 CST