Re: Off Topic: SQL-Tuning guide for developers (PeopleSoft)??

Any tuning guide for Oracle-Peoplesoft combination ?

• Deepak
  • Vidya Kalyanaraman <kvidya13_at_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_at_fatcity.com
    > To: Multiple recipients of list ORACLE-L
    > <ORACLE-L_at_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_at_inplan.de
    > http://www.inplan.de
    >
    >
    > --
    > Author: Schoen Volker
    > INET: v.schoen_at_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_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).
    >
    >

    ---

    
    > Get Your Private, Free E-mail from MSN Hotmail at
    > http://www.hotmail.com
    >
    > --
    > Author: Vidya Kalyanaraman
    > INET: kvidya13_at_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_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).
    

    ---