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 -----------------------------------------------------------------