Home » RDBMS Server » Performance Tuning » PL/SQL code review tool
PL/SQL code review tool [message #176708] Fri, 09 June 2006 04:30 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
we are in a need of a Tool which will help us review PL/SQL routines (Procedures, Functions, Packages).
The main purposes of reviwing above things are
1) If Standards are followed in the code
e.g. caller procedure is missing Exception handling while calling another procedure etc.
2) Performance related issues are handled in the code
e.g. using Exists instaed on IN operator wherever possible etc.

I have used Formatter Plus tool in TOAD, however it does not cover such things.
Please suggest a tool which covers (and handles such issues)

Thanks and Regards,
Pratap
Re: PL/SQL code review tool [message #176722 is a reply to message #176708] Fri, 09 June 2006 05:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> 2) Performance related issues are handled in the code
Oracle Tuning advisor may help to some extent.
Still, you need to apply some interpretation.
http://www.oracle-base.com/articles/10g/AutomaticSQLTuning10g.php

>>If Standards are followed in the code
I am not aware of any such tool.
Because, these are 'standards' and not 'rules'.
Re: PL/SQL code review tool [message #176750 is a reply to message #176722] Fri, 09 June 2006 07:29 Go to previous message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi Mahesh,
Is "Oracle Tuning advisor " specific to 10g?
We are using "Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production" on Linux environment.

Thanks and Regards,
Pratap
Previous Topic: Advice
Next Topic: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING
Goto Forum:
  


Current Time: Thu Mar 28 03:32:17 CDT 2024