Re: SQL and PL/SQL tuning template document required urgently

the only book out there that is any good is High Performance Tuning by Guy Harrison. Ignore the part where he says that a cursor with an update in the loop can be faster than using an update with where exists. That is inaccurate.

the rest is solid.

unforunately its not that simple. How you tune depends on the type of system you have. If your in an OLTP system with alot of concurrency, you tune heavily for Logical I/Os even if the query takes longer to run in isolation. If your doing batch queries, then you tune more for response time and less for logical I/Os.

its just not that simple.
>
> From: "Ranganath K" <Ranganath_K01_at_infosys.com>
> Date: 2003/10/29 Wed AM 09:24:25 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: SQL and PL/SQL tuning template document required urgently
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

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).