Oracle

1Z0-083 · Question #71

Which three are true about Optimizer Statistics Advisor? (Choose three.)

The correct answer is C. It can recommend changes to improve the statistics gathering process. E. It runs automatically every night by default. F. It is part of the DBMS_STATS package. https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2

Manage Database Performance

Question

Which three are true about Optimizer Statistics Advisor? (Choose three.)

Options

AIt can be run only manually.
BIt is part of the DBMS_ADVISOR package.
CIt can recommend changes to improve the statistics gathering process.
DIt always analyzes all schemas in the database.
EIt runs automatically every night by default.
FIt is part of the DBMS_STATS package.

How the community answered

(40 responses)

A
3% (1)
B
10% (4)
C
83% (33)
D
5% (2)

Explanation

https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2

Topics

#Optimizer Statistics Advisor#DBMS_STATS#statistics gathering#automated advisors

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-083 Practice