Which two are true about the Optimizer Statistics Advisor?

Question

Options

• AIt always analyzes all schemas in the database.
• BIt can recommend changes to improve the statistics gathering process.
• CIt can be run only manually.
• DIt runs automatically every night by default. E) It can be run only automatically.

• A
  7% (3)
• B
  88% (37)
• C
  5% (2)

Explanation

B and D are correct because the Optimizer Statistics Advisor (OSA) serves two core purposes: it analyzes how statistics are gathered and produces actionable recommendations (findings, recommendations, and rationale) to improve that process - satisfying B. It also runs automatically each night as part of Oracle's AutoTask framework within the default maintenance window - satisfying D.

Why the distractors fail:

• A is wrong - OSA does not blindly analyze every schema; it targets objects where statistics gathering can be improved, and scope can be configured.
• C is wrong - OSA runs automatically via AutoTask, so "only manually" is directly contradicted by D being true.
• E is wrong - OSA can be invoked manually using DBMS_STATS.ADVISOR, so "only automatically" is false.

Memory tip: Think of the two letters B and D as "Better statistics Daily" - the OSA makes statistics Better (recommendations) and runs Daily (automatic nightly task). Any choice using "only" (C or E) should immediately raise a red flag, as Oracle tools that run automatically almost always also allow manual invocation.

No community discussion yet for this question.