Message-Id: <10520.107941@fatcity.com>
From: Deepak Sharma <sharmakdeep@yahoo.com>
Date: Tue, 6 Jun 2000 11:49:31 -0700 (PDT)
Subject: Re: Off Topic: SQL-Tuning guide for developers (PeopleSoft)??

Any tuning guide for Oracle-Peoplesoft combination ?

- Deepak

--- Vidya Kalyanaraman <kvidya13@hotmail.com> wrote:
> Hi Volker...
> You can refer to
>   1. Optimising SQL by Peter Gulutzan and Trudy
> Pelzer....
>      It talks about optimising Rules of Thumb...some
> 17 rules....
>   2. Advanced Oracle tuning and administration By
> Eyal Aronoff et.al.        
>     by Oracle press...Explain plan and Hints....
>   3. Oracle SQL High- Performance Tuning, Guy
> Harrison           
> (Prentice-Hall,1997)(best of all)
> 
> Hope it helps.
> 
> Thanks
> Vidya
> 
> 
> 
> 
> Reply-To: ORACLE-L@fatcity.com
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L@fatcity.com>
> Date: Tue, 06 Jun 2000 05:17:06 -0800
> 
> Hi all,
> 
> I have the wonderful task to write down the
> guidelines for optimal use of
> SQL from point of performance criterea. I think this
> is written down
> sometimes before, so I don't want to invent the
> wheel new.
> 
> My question:
> Is there a internet-link or some kind of
> documentation (Oracle documentation
> I have browsed) how to use SQL from the point of
> performance, something like
> "never use..., better use...".
> 
> Any information is appreciated.
> 
> TIA
> 
> Volker Schön
> E-Mail: mailto:v.schoen@inplan.de
> http://www.inplan.de
> 
> 
> --
> Author: Schoen Volker
>    INET: v.schoen@inplan.de
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@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).
> 
>
________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
> 
> -- 
> Author: Vidya Kalyanaraman
>   INET: kvidya13@hotmail.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@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).


__________________________________________________