Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle query Tuning
The only answer you can get to this, provided the amount of details
you gave is: it depends. It depends on what you're trying to achieve,
which tools and methods you already know and used or considered
for use and rejected (reason?), etc. Please be more specific.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:askr0a$rk62g$1_at_ID-137434.news.dfncis.de...Received on Wed Dec 04 2002 - 06:15:19 CST
> 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
>
>