Task Operations

There are other useful APIs to be used along with the dbms_sqltune package for managing SQL tuning tasks. They are as follows:

• drop_tuning_task – used to drop a task and remove all associated results.
   

• reset_tuning_task – used to reset a task during execution to its initial state.
   

• interrupt_tuning_task – used to interrupt a task and exit with intermediate results.
   

• cancel_tuning_task – used to cancel a task execution and remove all results.

Next, the use of workload with SQL Access Advisor will be examined.

WorkLoad

The Workload consists of one or more SQL statements and various statistics and attributes for each statement. The workload is considered a full workload if it contains all SQL statements from a target application. Otherwise, for a subset of SQL statements, a workload is considered partial. 

For a full workload analysis, the SQL Access Advisor may recommend dropping some of the existing materialized views and indexes that are not being used effectively. Though the workload may contain a variety of statements, the SQL Access Advisor will rank the contents according to a specific statistic, business importance, or a combination of both.