| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 911 Article
I don't know Don's rate's, but my signature (quoting Derek Bok) gets more
strength. Look at the end of this message.
> Jonathan Lewis wrote:
>
>> Given that "The problem started when she wanted to
>> know the average row length for a table." I think we
>> can assume that the immediate fix to the problem was to
>> get rid of the stats from the one table, so the database
>> would go back to using RBO across the board.
>
> It seems to me that the real problem is a DBA who did not know how to
> retrieve
> average row length using SQL functions and did not understand the
> implications
> of analyzing only one table in a schema. This may be the result of a
> company not
> spending money on training, a person not taking the time to educate
> themselves,
> etc. Sure, the symptom is fixed, but what happens when this DBA begins to
> add
> db_block_buffers to achieve a 99.999% BCHR?
>
> Dan
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Mar 05 2004 - 12:48:02 CST
 |
 |