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