Re: Which Doc to Read

From: joel garry <joel-garry_at_home.com>
Date: 3 Jul 2006 11:24:41 -0700
Message-ID: <1151951081.665811.71110@a14g2000cwb.googlegroups.com>

Bob Jones wrote:
> "joel garry" <joel-garry_at_home.com> wrote in message
> news:1151701911.775407.193330_at_y41g2000cwy.googlegroups.com...
> >
> > Bob Jones wrote:
> >> "meathammer" <googler_at_google.com> wrote in message
> >> news:pan.2006.06.29.20.44.38.765000_at_google.com...
> >> > Currently working with 9iR2...
> >> > I want to start being a "good boy" DEVELOPER and start RTFM
> >> > on Performance Tuning doc:
> >> >
> >> > So which of the 2 below would you recommend I should go with at this
> >> > time ? (seems the older one has more material)
> >> > Thanks
> >> >
> >> > Performance Tuning Guide
> >> > 10g Release 2 (10.2)
> >> > B14211-01
> >> > June 2005
> >> >
> >> >
> >> > Database Performance Tuning Guide and Reference
> >> > Release 2 (9.2)
> >> > Part No. A96533-02
> >> > October 2002
> >>
> >> There is really not that much difference. 10g has automatic this and
> >> automatic that. I would use the 9i manual and never spend any money at
> >> the
> >> bookstores. There is nothing more comprehensive than the manuals.
> >
> > I put in 10053 in the tahiti search engine, and it sure didn't get
> > anything useful. You are just plain wrong, Bob. Put 10053 in the
> > knowledge browser at metalink, it ought to be obvious why a developer
> > serious about performance would want to know about such things.

> There will also be plenty of things you won't find in the books mentioned
> earlier. Should I go out and buy every book that is available?

No, but some people think what books you have available in your workspace and that show use are a reasonable indicator of what level of work you do. I don't quite agree with that, since some people might have their books at home or on electronic media or have an eidetic memory or whatever. But a statement that everything you need is in the manual - at best that means your work is limited, at worst you may be myth-mongering.

Personally, I do have shelves of Oracle books. Some are crap. I tend not to recommend those. Most are used infrequently, a few have little nuggets that make them worth having gone through once. The ones recommended in this thread are worth their weight in careers.

>


> >  In

> > particular, everyone should read the "How to Log a Good Performance

> > Service Request" note.  Simply going through the steps required to

> > delineate a problem can often solve it.  The other books mentioned in

> > this thread show how to solve such problems, and even decide if there

> > is a problem, too.
> >

>
> What problems? Any problems?

Well, this thread started about performance and what developers can do right. Simply following the instructions in the manuals may lead to problems - for example, where in the manuals does it explain possible performance issues with committing in a loop? How about the optimal way to perform DDL in a trigger? Where is X$KSQST explained? All developers are going to have superstitions and misconceptions about the best ways to do things with Oracle. Jeez, someone could write a whole book about these kinds of things. Maybe even more than one. The best ones demonstrate how even the most experienced developers need to question and test their assumptions.

-- 
@home.com is bogus.
http://www.plan59.com/images/JPGs/ed59church.jpg

Received on Mon Jul 03 2006 - 13:24:41 CDT

Re: Which Doc to Read - 10g or 9i ?