RE: DBMS_STATS

From: Grabowy, Chris <chris.grabowy_at_lmco.com>
Date: Wed, 28 Apr 2004 08:27:45 -0400
Message-id: <974B0BC4C9F3BB40B2651F8FC12B7B98A52141@emss04m12.us.lmco.com>

Try Wolfgang's presentation...Using DBMS_STATS in Access Path Optimization...

www.centrexcc.com/Using%20DBMS_STATS%20in%20Access%20Path%20Optimization .ppt.pdf

...its still on my pile of presentations to read.

I have had the pleasure of attending a few of Wolfgang's presentations, and he has a very crisp German (Austrian?) accent.

I keep meaning to mention that he should try an Arnold/Terminator themed presentation....

"Im going to terminate you if you stats are out of date!!".

To a developer...

"This query better execute in .035 seconds or I'm gonna execute you!!!"

Something like that...anyway, if you havent then checkout his other great papers...

http://www.centrexcc.com/

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Charlotte Hammond Sent: Wednesday, April 28, 2004 5:41 AM
To: ORACLE-L_at_freelists.org
Subject: DBMS_STATS

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 Wed Apr 28 2004 - 07:24:57 CDT