Dropping a SQL Tuning Set

This section describes how to drop a SQL tuning set. To conserve storage space, you may want to periodically drop unused SQL tuning sets stored in the database.

To drop a SQL tuning set:

1. Access the Database Home page.

   See "Accessing the Database Home Page" for more information.

2. From the Performance menu, select SQL, and then SQL Tuning Sets.

   If the Database Login page appears, then log in as a user with administrator privileges. The SQL Tuning Sets page appears.

3. Select the SQL tuning set you want to drop and then click Drop.

   The Confirmation page appears to verify that you want to drop the selected SQL tuning set.

4. Click Yes.

   The SQL Tuning Sets page appears.

   A confirmation message is displayed to indicate that the SQL tuning set was successfully dropped.