RE: Todays Oracle 11.2.0.2 quiz...

From: Don Granaman <DonGranaman_at_solutionary.com>
Date: Tue, 2 Aug 2011 11:42:44 -0500
Message-ID: <FD98CB0EE75EEA438CAF4DA2E6071C420EAA8D5796_at_MAIL.solutionary.com>

It looks like an OCP question doesn't it? So, without knowing anything about the topic, let us apply basic test-taking skills.

Since 3 of the answers involve sample size, we can safely assume that B and E are red herrings. Since D is a more specific subvariation of A, it is likely wrong. (Otherwise, A and D would both be "correct".) That leaves only A and C. Here I have to cheat and apply some actual Oracle/OCP logic. When in doubt, the defaults are always best. Right? (Remember the PCTINCREASE default of 50 for a few decades? ;-)

C. is my answer/guess.

Don Granaman | Phone: 402-361-3073 | Cell: 402-960-6955 | Fax: 402-361-3173 | Solutionary | Relevant . Intelligent . Security

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:

1. Manually set the sample size and not take the default.
2. Use the analyze command.
3. Use the default value for the sample size.
4. Use a sample size between 10 and 20.
5. 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-l

Received on Tue Aug 02 2011 - 11:42:44 CDT