Home » RDBMS Server » Performance Tuning » Check list to Tune an Application ( SQL & PL/SQL)
Check list to Tune an Application ( SQL & PL/SQL) [message #115641] Wed, 13 April 2005 06:07 Go to next message
Gurusubramanyam
Messages: 79
Registered: July 2001
Member
Hi,

Can anybody provide a checklist to tune a SQL and PL/SQL code.
I mean a sequential approach to tune.

Thanks,
G.S
Re: Check list to Tune an Application ( SQL & PL/SQL) [message #115655 is a reply to message #115641] Wed, 13 April 2005 08:32 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The documentation is the first place to start.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm

chapter 6 deals with Optimizing SQL Statements.


Please look into tools / options like explain plan,statspack,sqltrace, tkprof etc.
Previous Topic: STATSPACK
Next Topic: how to check whether index is rebuilt or not?
Goto Forum:
  


Current Time: Sun Sep 20 15:27:38 CDT 2020