Re: Todays Oracle 11.2.0.2 quiz...
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Howard Latham <howard.latham@xxxxxxxxx>, "ChrisDavid.Taylor@xxxxxxxxxxxxxxx" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2011 05:10:55 -0700 (PDT)
Pick only one.... :) The answer later today....
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is just
the opinion of one Oracle employee. I can be wrong, have been wrong in the past
and will be wrong in the future. If your problem is a critical production
problem, you should always contact Oracle support for assistance. Statements in
this email in no way represent Oracle Corporation or any subsidiaries and
reflect only the opinion of the author of this email.
________________________________
From: Howard Latham <howard.latham@xxxxxxxxx>
To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
Cc: "robertgfreeman@xxxxxxxxx" <robertgfreeman@xxxxxxxxx>;
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, August 3, 2011 2:51 AM
Subject: Re: Todays Oracle 11.2.0.2 quiz...
Do we have to pick one or can we pick up to 5?
On 2 August 2011 16:08, Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
wrote:
I would reason it this way.
>
>Not E because it’s a hidden parameter.
>Not B because analyze is bad.
>So, A, C, or D.
>
>Further:
>Oracle typically steers the standard DBA away from “manually” setting anything
>with each new release. So, I throw out A.
>Now, either C or D.
>
>Finally:
>Oracle also likes to keep default at default with each new release – If too
>many people are changing the same value consistently then they did a poor job
>configuring that value, so I’d say that the Oracle’s “preferred” answer is C.
>
>
>Chris Taylor
>Sr. Oracle DBA
>Ingram Barge Company
>Nashville, TN 37205
>Office: 615-517-3355
>Cell: 615-663-1673
>Email: chris.taylor@xxxxxxxxxxxxxxx
>
>CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
>may also be privileged. If you are not the named recipient, please notify the
>sender immediately and delete the contents of this message without disclosing
>the contents to anyone, using them for any purpose, or storing or copying the
>information on any medium.
>
>From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
>Behalf Of Robert Freeman
>Sent: Tuesday, August 02, 2011 9:17 AM
>
>To: oracle-l@xxxxxxxxxxxxx
>Subject: Todays Oracle 11.2.0.2 quiz...
>
>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?
>
>RF
>
>Robert G. Freeman
>Master Principal Consultant, Oracle Corporation, Oracle ACE
>Author of various books on RMAN, New Features and this shorter signature line.
>Blog: http://robertgfreeman.blogspot.com
>Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is just
>the opinion of one Oracle employee. I can be wrong, have been wrong in the
>past and will be wrong in the future. If your problem is a critical production
>problem, you should always contact Oracle support for assistance. Statements
>in this email in no way represent Oracle Corporation or any subsidiaries and
>reflect only the opinion of the author of this email.
>
>
>
--
Howard A. Latham
Sent from my Nokia N97
Other related posts:
