Accept_sql_profile
is both a procedure and function that creates the SQL Profile
recommended by the SQL Tuning Advisor. The SQL Text is supplied via
a SQL Tuning Task object. The function returns the name of the SQL
Profile as a VARCHAR2.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TASK_NAME
|
VARCHAR2
|
IN
|
|
|
OBJECT_ID
|
NUMBER
|
IN
|
NULL
|
|
NAME
|
VARCHAR2
|
IN
|
NULL
|
|
DESCRIPTION
|
VARCHAR2
|
IN
|
NULL
|
|
CATEGORY
|
VARCHAR2
|
IN
|
NULL
|
|
TASK_OWNER
|
VARCHAR2
|
IN
|
NULL
|
|
REPLACE
|
BOOLEAN
|
IN
|
FALSE
|
|
FORCE_MATCH
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.157:
Accept_sql_profile Parameters
Add_sqlset_reference
is a function that adds a new reference to a pre-existing SQL Tuning
Set (STS). The description can be up to 256 characters. It returns the
new reference's identifier as a NUMBER.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
DESCRIPTION
|
VARCHAR2
|
IN
|
NULL
|
Table 7.158:
Add_sqlset_reference Parameters
Alter_sql_profile
is a procedure that modified the specified attributes of a
pre-existing SQL Profile. The legal values for attributes to change
are STATUS, NAME, DESCRIPTION and CATEGORY.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
NAME
|
VARCHAR2
|
IN
|
|
|
ATTRIBUTE
|
VARCHAR2
|
IN
|
|
|
VALUE
|
VARCHAR2
|
IN
|
|
Table 7.159:
Alter_sql_profile Parameters
Cancel_tuning_task
is a procedure that terminates the currently executing tuning task
with a complete cleanup where all intermediate data is deleted.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TASK_NAME
|
VARCHAR2
|
IN
|
|
Table 7.160:
Cancel_tuning_task Parameter
Capture_cursor_cache_sqlset
is a procedure that incrementally captures workload activity from the
cursor cache into a SQL Tuning Set (STS). The capture time is
expressed in seconds, the capture option can be INSERT, UPDATE or
MERGE, and the capture mode can be either MODE_REPLACE_OLD_STATS or
MODE_ACCUMULATE_STATS.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
TIME_LIMIT
|
POSITIVE
|
IN
|
1800
|
|
REPEAT_INTERVAL
|
POSITIVE
|
IN
|
300
|
|
CAPTURE_OPTION
|
VARCHAR2
|
IN
|
'MERGE'
|
|
CAPTURE_MODE
|
NUMBER
|
IN
|
MODE_REPLACE_OLD_STATS
|
|
BASIC_FILTER
|
VARCHAR2
|
IN
|
NULL
|
|
SQLSET_OWNER
|
VARCHAR2IN
|
IN
|
NULL
|
Table 7.161:
Capture_cursor_cache_sqlset Parameters
Create_sqlset
is a both a procedure and function that creates a new SQL Tuning Set
(STS). When used as a function, it returns the name of the new SQL
Tuning Set as a VARCHAR2.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
DESCRIPTION
|
VARCHAR2
|
IN
|
NULL
|
|
SQLSET_OWNER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.162:
Create_sqlset Parameters
Create_stgtab_sqlprof
is a procedure that creates a staging table for copying SQL Profiles
across systems, like those for export and import operations.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TABLE_NAME
|
VARCHAR2
|
IN
|
|
Table 7.163:
Create_stgtab_sqlprof Parameter
Create_stgtab_sqlset_sqlprof
is a procedure that creates a staging table for copying SQL Tuning
Sets (STS) across systems, like those for export and import
operations.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TABLE_NAME
|
VARCHAR2
|
IN
|
|
|
SCHEMA_NAME
|
VARCHAR2
|
IN
|
NULL
|
|
TABLESPACE_NAME
|
VARCHAR2
|
IN
|
NULL
|
Table 7.164:
Create_stgtab_sqlset_sqlprof Parameters
