Re: Todays Oracle 11.2.0.2 quiz...
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: robertgfreeman@xxxxxxxxx
- Date: Tue, 2 Aug 2011 11:21:33 -0700
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
Other related posts:
