Re: Oracle 911 Article

From: Daniel W. Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 05 Mar 2004 08:54:23 -0700
Message-id: <4048A2AE.1D740CC8@sun.com>

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

Received on Fri Mar 05 2004 - 10:50:04 CST