Exporting a SQL Tuning Set

This section describes how to export a SQL Tuning Set, enabling it to be transported to another system.

To export a SQL Tuning Set: 

1. On the Database Performance page, under Additional Monitoring Links, click SQL Tuning Sets.

   The SQL Tuning Sets page appears.

   Existing SQL Tuning Sets are displayed on this page.

2. Select the SQL Tuning Set you want to export and then click Export.

   The Export SQL Tuning Set page appears.

3. In the Directory Object field, select a directory where the export file will be created.

   For example, to use the Oracle Data Pump directory, select DATA_PUMP_DIR. The Directory Name field refreshes automatically to indicate the selected directory.

4. In the Export File field, enter a name for the file to be database.

   Alternatively, you can accept the name generated by the database.

5. In the Log File field, enter a name for the log file for the export operation.

   Alternatively, you can accept the name generated by the database.

6. Select a tablespace to temporarily store the data for the export operation.

   By default, SYSAUX is used.

7. Under Job Parameters, in the Job Name field, enter a name for the job.

   Alternatively, you can accept the name generated by the database.

8. Under Schedule, do one of the following:

   • Select Immediately to run the job immediately after it has been submitted.

   • Select Later to run the job at a later time as specified by selecting or entering values in the Time Zone, Date, and Time fields.

9. Click OK.

   The SQL Tuning Sets page appears.

   A confirmation message indicates that the job was created successfully.

10. Transport the export file to another system using the mechanism of choice, such as Oracle Data Pump or a database link.