Re: Oracle query Tuning

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 04 Dec 2002 16:16:23 GMT
Message-ID: <3DEE2A54.7AA27B59@exesolutions.com>

Shafeek Khalidh wrote:

> All
>
> I need to tune the queries in the application. We have 389 stored procedures
> in the applicatation. Please suggest a way to tune them. Other than General
> SQL tuning, Explain plan and SQL Trace.
>
> Any suggestion for using Oracle Enterprise Performance Pack?
>
> Please guide me.
>
> Shafeek Khalidh

I'd suggest starting with the Oracle built-in package DBMS_PROFILER. There is excellent instruction on how to use it in Tom Kyte's book "Expert one-on-one Oracle".

Daniel Morgan Received on Wed Dec 04 2002 - 10:16:23 CST