RE: DBMS_STATS
- From: April Wells <AWells@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Apr 2004 07:14:27 -0500
Carel-Jan
It is a really good paper, one that I will now read over pretty
extensively... but I'm not sure it answers her questions on DBMS_STATS and
how best to collect statistics effectively.
I do want to see any good doc on it to. We are using DBMS_STATS in
production, in all of our instances, but I'm not comfortable that we are
implementing as well as we could, either.
ajw
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Carel-Jan Engel [mailto:cjpengel.dbalert@xxxxxxxxx]
Sent: Wednesday, April 28, 2004 6:53 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: DBMS_STATS
Charlotte,
Did you read Bjorn Engsig's paper
http://www.miracleas.dk/tools/Miracle_1_statspack.pdf
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
At 11:40 AM 4/28/2004, you wrote:
>Hi all,
>
>Can anyone please point me to any resources about "best practices" for
>DBMS_STATS in a production environment. I've RTFM'd and know about all
>the possible options (BLOCK_SAMPLE, METHOD_OPT) with a reasonable
>understanding (I think!) of what each does.
>
>But what's missing is how to put it all together effectively. (ie. I know
>what all the parts of the engine do, but I don't know how to drive...!)
>
>Many thanks
>- Charlotte
>
>
>---------------------------------
>Do you Yahoo!?
>Win a $20,000 Career Makeover at Yahoo! HotJobs
>
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------
----------------------------------------------------------------
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 information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
----------------------------------------------------------------
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:
