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

FiGURe 9.17 Schedule SQL Tuning Advisor page
FiGURe 9.18 SQL Tuning Sets
4. Click the Create button; this will begin the process to create a new SQL tuning set.
a. Step 1 is to type a name for your tuning set, the schema owner, and a description,
as shown in Figure 9.19. Then click Next to continue.
b. Step 2 is to choose the load methods; in this case, as shown in Figure 9.20, specify
a duration of 24 hours with samples taken at 5-minute intervals. Then click Next.
c. In step 3 you set criteria for SQL statements to include in the tuning set, as shown
in Figure 9.21. The drop-down menu allows you to select from a predefined list
to add additional filter attributes. For this example we would like to see all of the
SQL statements, so do not apply filter conditions. Then click Next.