This flowchart diagram shows the steps performed by Oracle Database during the automatic SQL tuning process.

Starting from the top of the diagram, AWR leads to:

  1. Identify SQL tuning candidates

  2. Generate recommendations

  3. Test SQL profiles

  4. Implement SQL profiles

These four steps are wrapped inside a dotted area which points to the automatic SQL tuning reports on the right side of the diagram.

End of image description.