Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle query Tuning

Re: Oracle query Tuning

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 4 Dec 2002 15:15:19 +0300
Message-ID: <askrtt$7o7$1@babylon.agtel.net>


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...

> 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
>
>
Received on Wed Dec 04 2002 - 06:15:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US