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

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: STATSPACK
Next Topic: how to check whether index is rebuilt or not?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 02 02:27:29 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.