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

Ryan,

  'can be faster' is rarely inaccurate. It all depends.

SF

>----- ------- Original Message ------- -----
>From: <ryan_oracle_at_cox.net>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Wed, 29 Oct 2003 06:49:33
>
>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: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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).