| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL and PL/SQL tuning template document required urgently
Dennis,
Excellent recommendation, Guy Harrison's book (2nd Edition) is excellent the best I've seen on SQL tuning. I've used it for a number of years. I had the 1st edition and then bought the 2nd when it came out.
Cheers,
Chris
-----Original Message-----
Sent: 29 October 2003 15:49
To: Multiple recipients of list ORACLE-L
Ranganath
Since you mentioned proactive and reactive query tuning, I think the philosophy with which one approaches the tuning exercise means everything. Wrong philosophy and you spend your time spinning your wheels. All of us have only a limited amount of time to devote, so the best approach will make the best use of that time.
Get "Optimizing Oracle Performance" by Cary Millsap. It doesn't take long to read the important parts. Implement Cary's approach to locate the queries where you will get the most bang for the buck. Then use books like Guy Harrison's (Ryan's suggestion) for pointers on making those queries perform better.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, October 29, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Hi there,
Does any body have a template for proactive and reactive query tuning which can be used as a guideline/report while tuning simple, medium complex and complex SQL queries and PL/SQL stored procedures? If so, can you please forward the same to me please? If not, can anybody suggest as to how to go about doing one? Any help in this regard is very much appreciated.
Thanks and Regards,
Ranganath
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ranganath K
INET: Ranganath_K01_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 28 2003 - 03:24:26 CST
 |
 |