From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Tuning Checklist & Software / Spotlight on Oracle
Date: Tue, 12 Dec 2000 21:15:33 +0100
Lines: 47
Message-ID: <9169df$33spg$2@ID-62141.news.dfncis.de>
References: <91608v$vlc$1@nnrp1.deja.com>
NNTP-Posting-Host: sybrandb.demon.nl (212.238.21.78)
X-Trace: fu-berlin.de 976660719 3273520 212.238.21.78 (16 [62141])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300


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@my-deja.com> wrote in message news:91608v$vlc$1@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/