Re: Oracle performance tuning

From: Simon Kelly <simon_at_skelly.demon.co.uk>
Date: 1996/11/29
Message-ID: <01bbddf9$7ff66530$be3adec2@skelly>#1/1

While the application is running, try using the utlbstat and utlestat scripts (they can be found in $ORACLE_HOME/rdbms/admin). Analyzing the produced report should show any bottlenecks in the database and should highlight if your SQL is performing badly (eg lots of long table scans). Once the bottleneck area has been established you can either tune the instance (through the initialisation parameters) or the applicaiton as required (eg by explaining SQL etc).

Such performance data should be used in conjunction with performance data from the operating system (eg. cpu and disk utilisation) as there may be a bottleneck there.

Regards....Simon Received on Fri Nov 29 1996 - 00:00:00 CST