1. Get Started with Performance Tuning
  2. SQL Tuning
  3. Tuning SQL Statements
  4. Managing SQL Tuning Sets
  5. Creating a SQL Tuning Set
  6. Creating a SQL Tuning Set: Load Methods
  7. Loading SQL Statements from a User-Defined Workload

Loading SQL Statements from a User-Defined Workload

You can load SQL statements by importing from a table or view. This technique is useful if the workload you want to analyze is not currently running on the database or captured in an existing AWR snapshot or AWR baseline.

There are no restrictions on which schema the workload resides in, the name of the table, or the number of tables that you can define. The only requirement is that the format of the table must match format of the USER_WORKLOAD table.

To load SQL statements from a user-defined workload:

  1. Access the Create SQL Tuning Set: Load Methods page, as explained in "Creating a SQL Tuning Set: Options".

  2. Select Load statements one time only.

  3. In the Data Source field, select User-Defined Workload.

  4. In the User-Defined Workload field, select the table or view to include.

    Description of sts_load_workload.gif follows
    Description of the illustration sts_load_workload.gif

  5. Click Next.

    The Create SQL Tuning Set: Filter Options page appears.

  6. Proceed to the next step, as described in "Creating a SQL Tuning Set: Filter Options".