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: tuning store procedures

Re: tuning store procedures

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 14 Jan 2002 22:25:25 +0000
Message-ID: <3C435AD5.DF0623A7@exesolutions.com>


Start with EXPLAIN PLAN, TKPROF, DBMS_PROFILER, and a copy of Tom Kyte's book.

Tuning is not something you can describe in a usenet posting ... in fact it is not even something you can master after taking a 35 hour course from Oracle on the subject. Find a mentor and use the above tools.

Daniel Morgan

tshen wrote:

> hi,
>
> how can I tuning store procedure which contains several pl/sql blocks
> and SQL statements. thanks.
>
> Tao
Received on Mon Jan 14 2002 - 16:25:25 CST

Original text of this message

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