Re: good sources for tuning info

Ryan wrote:
>
> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
> news:3EB9BDE9.3CB5_at_yahoo.com...
> > Greg Teets wrote:
> > >
> > > On Wed, 07 May 2003 21:39:27 GMT, "Ryan" <rgaffuri_at_cox.net> wrote:
> > >
> > > >I have Performance Tuning 101 and Guy Harrisons High Performance
> Tuning. I
> > > >read the Niemic book which I know is unpopular.
> > > >
> > >
> > > Why is it unpolular? I thought it was pretty good.
> > >
> > > Thanks.
> >
> > Many will people will disagree - but it IS a very good book. I have
> > used it on more than one occasion to save my skin, for example:
> >
> > a) standing on it to reach an item on a high shelf
> > b) getting a BBQ fire started
> > c) an alternative for the dog chewing my socks
> > d) stopping the car from rolling down a hill
> >
> > Make no mistake, there are plenty of uses
> >
> > :-)
> >
> >
> > --
> > =========================
> > Connor McDonald
> > http://www.oracledba.co.uk
> >
> > "Some days you're the pigeon, some days you're the statue"
>
> Conner,
>
> do you know any other good sources for SQL tuning? The books seem to provide
> the basics, but there are lots of possible cases. Trial and error is very
> time consuming. How is the Burleson Tuning book? Any good sites other than
> the ones I listed? Ive been to your site.

Books I like:

• the ones from listed on site
  • Expert 1-on-1 (Kyte)
  • Lock,latches,waits (Adams)
  • Scaling 8i (Morle)
  • Practical 8i (Lewis)
• others
  • Performance Tuning 101 (I haven't got it but its rated well)

the 9.2 doco for performance tuning is also a good resource, much better than it was in earlier oracle versions

Patience is a virtue - both Tom Kyte and Cary Millsap are releasing books later this year. The sneak-peaks I've been given suggest both will be quite spectacular.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"