Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tuning store procedures
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