Re: Oracle 911 Article
- From: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 5 Mar 2004 19:16:43 +0100 (CET)
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
