Re: Oracle 911 Article

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: