Databases Reference
In-Depth Information
Figure 10-5. Scheduling options for the SQL Advisor Task
If everything looks okay, click the Next button. You should see a screen similar to the one shown in
Figure 10-6. One important feature to notice on this screen is the Show SQL button. This allows you to
preview the SQL and PL/SQL that SQL Access Advisor will run when you submit the job. The amount of
code produced can be quite voluminous. The following lines of code show just a small snippet of the
PL/SQL produced:
DECLARE
taskname varchar2(30) := 'SQLACCESS2522132';
task_desc varchar2(256) := 'SQL Access Advisor';
task_or_template varchar2(30) := 'SQLACCESS_EMTASK';
