79742

Configuring the Automatic SQL Tuning Advisor

The fol łowi ng are some configuration tasks that you might want to perform for the Automatic SQL Tuning Advisor:

■Enable automatic implcmentation of SQL profile recommendations.

Automatic implcmentation is disablcd by default.

■Change the maximum number of SQL profiles implemcntcd during one run of the SQL Tuning Advisor

When automatic implcmentation of SQL profile recommendations is cnablcd, 20 SQL profiles are implemcntcd during a run of the SQL Tuning Advisor, by default.

■Change the maximum number of SQL profiles that can be implemcntcd ovcrall. When automatic implcmentation of SQL profile recommendations is cnablcd. a total of 10000 SQL profiles can be implemcntcd by SQL Tuning Advisor. by default.