| 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
Where is this now-infamous article? I'm sorry, I missed the original
post, I guess.
Lisa Koivu
Sushi Monkey
Orlando, FL, USA
-----Original Message-----
From: Daniel W. Fink [mailto:Daniel.Fink_at_Sun.COM]
Sent: Friday, March 05, 2004 10:54 AM
To: oracle-l_at_freelists.org
Subject: 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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." ---------------------------------------------------------------- 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 - 12:58:27 CST
 |
 |