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 -> Tuning PL/SQL Procedures

Tuning PL/SQL Procedures

From: GeoPappas <PappasG_at_gmail.com>
Date: 3 Nov 2005 07:25:47 -0800
Message-ID: <1131031547.194467.279820@f14g2000cwb.googlegroups.com> 





I am familiar with the ability to tune a SQL statement, but is there a
way to tune a procedure?



For example, we have a procedure in PL/SQL that is a few hundred lines.
 I would like to test the procedure and capture a benchmark.  I would
then like to try various things to try and improve performance.



Is utlbstat/utlestat the best way?



Are there other ways?



FYI: Using Oracle 10g on Solaris 2.9
Received on Thu Nov 03 2005 - 09:25:47 CST












Original text of this message













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