I'd say see the first result from this URL: http://bit.ly/o5xTGJ On Tue, Aug 2, 2011 at 7:16 AM, Robert Freeman <robertgfreeman@xxxxxxxxx>wrote: > Without looking in the docs, answer this question: > > When collecting Oracle statistics in 11.2.0.2 (generally, there are always > fringe cases) you should: > > A. Manually set the sample size and not take the default. > B. Use the analyze command. > C. Use the default value for the sample size. > D. Use a sample size between 10 and 20. > E. Set the _optimizer_stats_modify parameter first to a value of 60. > > What is your answer and why? > > -- Regards, Greg Rahn http://structureddata.org