Re: Todays Oracle 11.2.0.2 quiz...

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 2 Aug 2011 10:27:40 -0500
Message-ID: <CAJvnOJYGn60GzaEnv98tSe66Mp+tzhHZgFf5qdoyr1aSfxxRJQ_at_mail.gmail.com>

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_at_environment-agency.gov.uk> 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.'

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 02 2011 - 10:27:40 CDT