RE: Oracle 911 Article
- From: "Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Mar 2004 13:45:16 -0500
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@xxxxxxx]
Sent: Friday, March 05, 2004 10:54 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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
-----------------------------------------------------------------
"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@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:
