Re: Finding full-table scans?

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:jdBja.7783$1s1.115741_at_newsfeeds.bigpond.com...
>
> "Don Burleson" <don_at_burleson.cc> wrote in message
> news:998d28f7.0304050339.1d06c62a_at_posting.google.com...
> > Here is the script that I use to locate FTS.
> >
> > A also have lot's more SQL scripts in my latest book, Creating a
> > self-tuning Oracle Database.
> >
> > http://www.dba-oracle.com/bp/bp_book3_oracle9i_sga.htm
>
> Warning: Humbug Alert.
>
> And then tell me why I should buy your book when not three months ago you
> were posting information that was technically inaccurate and eight years
out
> of date, yet offering it as good advice for current databases.
> (Incidentally, it was technically inaccurate eight years ago, too, but I
> couldn't be bothered to point it out to you at the time).

I have a copy of book "performance tuning using statspack" by Don Burleson, it is a great book, a lot of innovative ideas and very informative.

Of course there is a little bit incorrect statement, like "if table A is analyzed while table B is not, Oracle optimizer will dynamically analyze first 5000 rows of table A", but you can not expect a book be completely clean of mistakes. I like reading his books. Received on Sun Apr 06 2003 - 21:20:27 CDT