What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

The correct answer is B. SQL profile recommendations. https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: During the tuning process, all recommendation types are…

New Features for Performance

Question

Options

Astatistics recommendations
BSQL profile recommendations
CSQL statement restructure recommendations
Dcreation of materialized views to improve query performance

How the community answered

(45 responses)

A
11% (5)
B
78% (35)
C
7% (3)
D
4% (2)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.

Topics

#SQL Tuning Advisor#automated maintenance#SQL profiles#automatic implementation

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice