Databases Reference
In-Depth Information
Table 10-1. Parameters of DBMS_ADVISOR.QUICK_TUNE Procedure
Parameter
Description
advisor_name
Advisor that performs the analysis. For example,
DBMS_ADVISOR.SQL_ACCESS_ADVISOR
.
task_name
Name of the task.
attr1
For SQL Access Advisor, this is a CLOB that holds the SQL statement being
analyzed.
attr2
For SQL Access Advisor, this is the user account name. This parameter is optional;
the default is the currently connected user.
attr3
Optional advisor attribute in the form of a number.
task_or_template
Optional task name of an existing task or template.
Table 10-2. Parameters of the DBMS_ADVISOR.GET_TASK_SCRIPT Function
Parameter
Description
task_name
Unique task name that identifies the task for which advice is being reported.
Type
Type of script. Default value is
IMPLEMENTATION
; the other valid value is
UNDO
.
rec_id
Recommendation identifier used to display a subset of the implementation
script. Default is
NULL
.
act_id
Value used to specify whether all recommendations should be included.
Default is
NULL
.
owner_name
Task owner name. If omitted, the currently connected user is assumed to be
the task owner.
execution_name
Identifies a specific execution of the task. Default is
NULL
.
object_id
Identifier of an advisor object for the task. Default is
NULL
.
Obtaining Advice for a Group of SQL Statements
To make full use of the SQL Access Advisor features, we strongly recommend you use the Enterprise
Manager SQL Access Advisor Wizard. This browser-based interface allows you to visually select from a
vast number of features and options. Using this graphical tool is much more efficient than trying to
manually generate the code required when using the
DBMS_ADVISOR
PL/SQL package. Keep in mind that
