Re: Finding full-table scans?

I usually don't feel the need to rebuke messages here, but I can't help it this time. Is the man's script above inaccurate or flawed? Looks to me like it's something people on this board can use as is or modify to fit their needs. In other words, it's something of worth and demonstrates what boards like this are all about: DBA's helping DBA's. Your message helps no one and serves no purpose. And where's your actual answer to the original question and script that helps the one who posted?

Rob

"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.
>
> Please tell me what is self-tuning about being able to dynamically resize
> bits of the SGA with SQL commands you have to type in yourself?? From your
> table of contents, it would appear that you believe a self-tuning PGA counts
> as a self-tuning database.
>
> 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).
>
> The day you stop proclaiming yourself to be "one of the world's top Oracle
> Database experts", and actually start demonstrating it, I'll shut up. Until
> then, I'll just keep quietly pointing out what a fraud you are anytime you
> pop up here.
>
> HJR
Received on Sat Apr 05 2003 - 19:58:53 CST