Diagnosing the Database and Managing Performance - OCP: Oracle Database 12c Administrator Certified Professional - page 422

5. Return to the SQL Tuning Sets page and select the name of the SQL tuning set you
wish to investigate.
You should receive quick confirmation that SQL collection is in progress—the SQL
statements count will increase.
6. After you have collected SQL statements in a set, you can run the SQL Tuning Advisor
using the tuning set. In Figure 9.25, we identify which SQL tuning set to process.
FiGURe 9.25 SQL tuning set selection
7. Select a tuning set, and you will be taken to the SQL Tuning Set results page.
8. You can filter the results to a manageable amount that you can review by selecting
Search For SQL Within Tuning Set, as shown in Figure 9.26.
FiGURe 9.26 SQL Tuning Advisor results