Re: Todays Oracle 11.2.0.2 quiz...
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 2 Aug 2011 11:21:33 -0700
Message-ID: <CAGXkmivA4cgxo08n=qdR3HWgysyfXWHQgM332hgV05RTjFbbmQ_at_mail.gmail.com>
I'd say see the first result from this URL: http://bit.ly/o5xTGJ
Date: Tue, 2 Aug 2011 11:21:33 -0700
Message-ID: <CAGXkmivA4cgxo08n=qdR3HWgysyfXWHQgM332hgV05RTjFbbmQ_at_mail.gmail.com>
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_at_yahoo.com>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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 02 2011 - 13:21:33 CDT