Re: good sources for tuning info

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3EB9FF2B.24EA_at_yahoo.com>...
> 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

thanks conner. Ive read most of Kytes book. Havent hit Steve Adam's yet, though his website is great. I REALLY hope some tuning Guru sits down and write a nice 1000 page tome covering all aspects of SQL Tuning with lots of different tricks and examples. They are out there, no one has written it :(. Id be the first one to buy it.

There is another Internals book out this somewhere by a group of authors. Im gonna grab that one also. I just have deadlines and gotta get this silly query to run right. Received on Thu May 08 2003 - 07:11:52 CDT