Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Section 10: The SQL Access Advisor > Performing A Quick Tune Task
Performing A Quick Tune Task
While the SQL Access Advisor can be used programmatically, it is more involved than programmatic access for other database tools we have considered. One must create a task, define the workload, execute the task and then view the recommendations. Thus, generally one will want to use the EM interface.
As an alternative, one can occasionally use the quick tune option of the SQL Access Advisor. This launches the Advisor with a workload of one SQL statement in a single step. The recommendations may be quickly viewed and implemented if desired.
Example
Notice the simple PL/SQL program shown in the example below. Using a SQL99 form of one of the same SQL statements we have been tuning all along a quick tune task is defined and executed.