Re: Tuning Checklist & Software / Spotlight on Oracle

Niemic contains a tuning methodology and checklist.

Other than that the checktuning script on http://www.ipass.net/~davesisk/oont.htm
also provides useful results.

Apart from Niemic Oracle High Performance Tuning by Guy Harrison is worth to own.

Hth,

Sybrand Bakker, Oracle DBA

<dmnwork_at_my-deja.com> wrote in message news:91608v$vlc$1_at_nnrp1.deja.com...
>
>
> Can someone point me to a good Oracle tuning checklist? I want to do
> performance reviews of several Oracle databases running on different
> OSes and different versions of Oracle.
>
> What tool would I use to collect statistics / build a benchmark over,
> say, a week's time? (buffer cache hit ratio, etc) I want to have a
> standard by which to measure any tweaks I make. Trying not to reinvent
> the wheel. Any freeware stuff out there? What do people think of Quest
> Software's "Spotlight On Oracle?"
>
> Does the act of monitoring an Oracle database skew the performance
> results?
>
> What's *the* best perf tuning book for Oracle 8+? I've got Niemiec's
> Oracle Press book "Oracle Performance Tuning." Wish O'Reilly would take
> the time to update their Oracle tuning book; haven't read it, but I've
> heard it only covers 7.3.
>
> Thanks a million.
>
> - Dana
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Dec 12 2000 - 14:15:33 CST