1. Get Started with Performance Tuning
  2. SQL Tuning
  3. Tuning SQL Statements
  4. Managing SQL Tuning Sets
  5. Transporting SQL Tuning Sets
  6. Importing a SQL Tuning Set

Importing a SQL Tuning Set

Before a SQL tuning set can be imported, you must first export a SQL tuning set from another system and transport it to your current system.

See Also:

"Exporting a SQL Tuning Set" for more information

To import 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, 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. Click Import From A File.

    The Import SQL Tuning Set page appears.

  4. In Directory Object, select the directory containing the file to be imported.

    The directory should contain the export file that was transported to your current system. For example, if the file resides in the Data Pump directory, then select DATA_PUMP_DIR. The Directory Name field refreshes automatically to indicate the selected directory.

  5. In the Import File field, enter the name of the dump file to import.

  6. In the Log File field, enter a name for the log file for the import operation.

  7. To replace an existing SQL tuning set with the one that you are importing, select Replace the existing SQL tuning set if one exists.

  8. Select a tablespace to temporarily store the data for the import operation.

    By default, SYSAUX is used.

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

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

    Optionally, in the Description field, enter a description of the tuning set.

  10. 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.

  11. Click OK.

    The SQL Tuning Sets page appears.

    A confirmation message appears that indicates that the job was successfully created. If the job is scheduled to run immediately, then the imported SQL tuning set is shown on this page. You may need to refresh to see the SQL tuning set.