Re: SPEED-UP OPERATION

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Fri, 2 Jun 2000 12:10:02 +0200
Message-Id: <10516.107524@fatcity.com>

On Fri, Jun 02, 2000 at 01:09:11AM -0800, drichard_at_mtlindia.com wrote:
>
> Dear Experts
>
> I have been asked by the Management and Database Users to speed up the
> application. For that I would like to know what are all the definitions in the
> back-end
> can be modified to increase the Speed of all queries.
>
> We are using Oracle7 Workgroup Server Release 7.3.2.2.1 on
> Windows NT4 Box.
>
> Please give me few effective hints on what I have to study and implement
> on the Database ?

Take a look at the tuning and performance section of your documentation. Oracle has hundreds of screws that are reponsible for performance.

Maybe you should run the Orasnap utility (http://www.stewartmc.com/oracle/orasnap). This gives you a very close overview to all parts of your database. Received on Fri Jun 02 2000 - 05:10:02 CDT