RE: Todays Oracle 11.2.0.2 quiz...

  • From: Herring Dave - dherri <Dave.Herring@xxxxxxxxxx>
  • To: "robertgfreeman@xxxxxxxxx" <robertgfreeman@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 4 Aug 2011 14:03:56 +0000

In terms of answering this as a test from Oracle (OCP or otherwise) I'd say 
"C", since I believe Oracle's goal is to make it's product as self-managing as 
possible so DBAs don't have to "adjust" all the different options and controls. 
 

If I ever worked on an env where the above was true I'd probably be insanely 
bored.  And if we all did this list would be boring as well.  Here's to 
supporting buggy Oracle releases, pushing limits of what's practical, and 
answering to unrealistic expectations!!!

DAVID HERRING
DBA
Acxiom Corporation
EML   dave.herring@xxxxxxxxxx
TEL    630.944.4762
MBL   630.430.5988 
1501 Opus Pl, Downers Grove, IL 60515, USA
WWW.ACXIOM.COM  
________________________________________
The information contained in this communication is confidential, is intended 
only for the use of the recipient named above, and may be legally privileged. 
If the reader of this message is not the intended recipient, you are hereby 
notified that any dissemination, distribution or copying of this communication 
is strictly prohibited. If you have received this communication in error, 
please resend this communication to the sender and delete the original message 
or any copy of it from your computer system. Thank you.

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.



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


Other related posts: