RE: Todays Oracle 11.2.0.2 quiz...
Date: Thu, 4 Aug 2011 14:03:56 +0000
Message-ID: <BD475CE0B3EE894DA0CAB36CE2F7DEB420434056_at_LITIGMBCRP02.Corp.Acxiom.net>
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_at_acxiom.com 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman
Sent: Tuesday, August 02, 2011 9:17 AM
To: oracle-l_at_freelists.org
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:
- Manually set the sample size and not take the default.
- Use the analyze command.
- Use the default value for the sample size.
- Use a sample size between 10 and 20.
- 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 04 2011 - 09:03:56 CDT