Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Tools
sMiLeY wrote:
>
> Hello, could some one please tell me what the best performance
> tools are available?.
>
Unfortunally, the best performance-tools for an Oracle-DB are:
- your brain, - your SQL-Scripts - your brain - your brain
there are many (and i MEAN many) screws to drive in an Oracle-DB and
every tool handles some of them, but NONE covers all possibilities of
tuning Oracle.
There are some books with useful scripts to analyze your system. I use a
few scripts from D.K. Burleson.
But the tuning has to be done by yourself. Therefore you can use the
Oracle Enterprise-Manager parts (NOT the EM itself ;-) ). But to know
what to tune is best done with intelligent scripting in SQL*Plus or
SQL*Worksheet.
Sorry :-)
Olaf
-- Dipl.-Inform. Olaf Musch GZS mbH Gesellschaft für Zahlungssysteme Unternehmensbereich Processing Abt. AE - CS Theodor-Heuß-Allee 80 60486 Frankfurt mailto:Olaf.Musch_at_gzs.de ------------------------------------------------------------ http://www.gzs.de http://www.eurocard.deReceived on Fri Jun 06 1997 - 00:00:00 CDT