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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
