Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Finding full-table scans?

Re: Finding full-table scans?

From: Mike Ault <mikerault_at_earthlink.net>
Date: 5 Apr 2003 15:53:41 -0800
Message-ID: <37fab3ab.0304051553.1590318e@posting.google.com>


"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
Howard,

We are all entitled to our opinions. However, whether or not the advice given in past postings was correct or not bears little on whether the information currently posted is good or not. In this case, the script does as specified. if a small bit of self promotion is a crime then all of us are guilty.

Besides, I don't see you answering the question, so perhaps you should just keep quiet unless you have something constructive to say.

Mike Ault Received on Sat Apr 05 2003 - 17:53:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US