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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tuning PL/SQL

Re: tuning PL/SQL

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Mon, 30 Aug 2004 18:23:46 -0700 (PDT)
Message-ID: <20040831012346.68069.qmail@web50603.mail.yahoo.com>


Hi,

The 9.2 Oracle docs on DBMS_PROFILER start here: http://tinyurl.com/6pwmf

It would help identify specific portions of code to for optimization work. For example, this might give you prioritized information on which SQL statements need tuning (based on response time).

2) I believe the Hotsos SQL test harness can now profile PL/SQL, including statistics and timed events, based on my review of the latest test harness version. But, this is a relatively new feature, and I have not tested it yet. Docs says it does not do plans on SQL statements within PL/SQL.

3) There are other good methods to measure PL/SQL performance. Examples include code in C McDonald's new PL/SQL book, and using logoff session triggers to gather OWI related details suggested in the new OWI book.

HTH. Good luck.

Regards,

Mike Thomas                 



Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Aug 30 2004 - 20:19:24 CDT

Original text of this message

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