Re: Todays Oracle 11.2.0.2 quiz...

Well, 11.2.0.2 defaults to a sample size of 100, and it appears that it also
sets up a job to run stats automatically (though mine has been errorring
out), so my guess is E.

On Tue, Aug 2, 2011 at 9:47 AM, Dunbar, Norman (Capgemini) <
norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> **
> Hi Robert,
>
> >  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?
>
> Ok, I'm not clued up on 11.2 yet, and without looking in the docs, I'd say
> E is correct because it is the one that most people will avoid due to it
> having a leading underscore! ;-)  So it absolutely has to be right!
>
> However, I'd also pick A on the potentially vague hope that I'm in command.
>
> Cheers,
> Norm.
>
>
>
>
>
>  Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.******
>
> ** **
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.****
>
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for litigation.
> Email messages and attachments sent to or from any Environment Agency
> address may also be accessed by someone other than the sender or recipient,
> for business purposes.****
>
> ** **
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506.  Find
> out more about the Environment Agency at www.environment-agency.gov.uk****
>
> ****
>



-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Other related posts: