Load_sqlset
is a procedure that populates the user specified SQL Tuning Set
(STS) with the set of selected SQL statements. It can be run
multiple times and the results are simply aggregated. The valid load
options are INSERT, UPDATE and MERGE. The valid update options are
REPLACE and ACCUMULATE. The valid update conditions are OLD and NEW.
The valid update attributes are NULL, BASIC, TYPICAL, ALL and a
comma separated list of execution context attributes.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
POPULATE_CURSOR
|
SQLSet_Cursor
|
IN
|
|
|
LOAD_OPTION
|
VARCHAR2
|
IN
|
'INSERT'
|
|
UPDATE_OPTION
|
VARCHAR2
|
IN
|
'REPLACE'
|
|
UPDATE_CONDITION
|
VARCHAR2
|
IN
|
NULL
|
|
UPDATE_ATTRIBUTES
|
VARCHAR2
|
IN
|
NULL
|
|
IGNORE_NULL
|
BOOLEAN
|
IN
|
TRUE
|
|
COMMIT_ROWS
|
POSITIVE
|
IN
|
NULL
|
|
SQLSET_OWNER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.176:
Load_sqlset Parameters
Pack_stgtab_sqlprof
is a procedure that simply copies the SQL Profile data from SYS to the
user specified staging table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
PROFILE_NAME
|
VARCHAR2
|
IN
|
'%'
|
|
PROFILE_CATEGORY
|
VARCHAR2
|
IN
|
'DEFAULT'
|
|
STAGING_TABLE_NAME
|
VARCHAR2
|
IN
|
|
|
STAGING_SCHEMA_OWNER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.177:
Pack_stgtab_sqlprof Parameters
Pack_stgtab_sqlset
is a procedure that simply copies the SQL Tuning Set from SYS to the
user specified staging table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
SQLSETOWNER
|
VARCHAR2
|
IN
|
NULL
|
|
STAGING_TABLE_NAME
|
VARCHAR2
|
IN
|
|
|
STAGING_SCHEMA_OWNER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.178:
Pack_stgtab_sqlset Parameters
Remap_stgtab_sqlprof
is a procedure that permits modifications to the SQL Profile data in
the staging table prior to extraction.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OLD_PROFILE_NAME
|
VARCHAR2
|
IN
|
|
|
NEW_PROFILE_NAME
|
VACRHAR2
|
IN
|
NULL
|
|
PROFILE_CATEGORY
|
VARCHAR2
|
IN
|
'DEFAULT'
|
|
STAGING_TABLE_NAME
|
VARCHAR2
|
IN
|
|
|
STAGING_SCHEMA_OWNER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.179:
Remap_stgtab_sqlprof Parameters
Remap_stgtab_sqlset
is a procedure that permits modifications to the STS data in the
staging table prior to extraction.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OLD_SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
OLD_SQLSET_OWNER
|
VACRHAR2
|
IN
|
NULL
|
|
NEW_SQLSET_NAME
|
VACRHAR2
|
IN
|
NULL
|
|
NEW_SQLSET_OWNER
|
VACRHAR2
|
IN
|
NULL
|
|
STAGING_TABLE_NAME
|
VARCHAR2
|
IN
|
|
|
STAGING_SCHEMA_OWNER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.180:
Remap_stgtab_sqlset Parameters
Remove_sqlset_reference
is a procedure that drops an existing reference to a pre-existing SQL
Tuning Set.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQLSET_NAME
|
VARCHAR2
|
IN
|
|
|
REFERENCE_ID
|
NUMBER
|
IN
|
|
Table 7.181:
Remove_sqlset_reference Parameters
Report_auto_tuning_task
is a function that displays a report based upon the automatic tuning
task data. It returns that report as a CLOB.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
BEGIN_EXEC
|
VARCHAR2
|
IN
|
NULL
|
|
END_EXEC
|
VACRHAR2
|
IN
|
NULL
|
|
TYPE
|
VACRHAR2
|
IN
|
TYPE_TEXT
|
|
LEVEL
|
VACRHAR2
|
IN
|
LEVEL_TYPICAL
|
|
SECTION
|
VARCHAR2
|
IN
|
SECTION_ALL
|
|
OBJECT_ID
|
NUMBER
|
IN
|
NULL
|
|
RESULT_LIMIT
|
VARCHAR2
|
IN
|
NULL
|
|
SEGMENT_SCHEME
|
VARCHAR2
|
IN
|
SEGMENT_NONE
|
Table 7.182:
Report_auto_tuning_task Parameters
Report_sql_monitor
is a function that displays a report based upon the real time SQL
monitoring data being captured. It returns that report as a CLOB.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
SQL_ID
|
VARCHAR2
|
IN
|
NULL
|
|
SESSION_ID
|
NUMBER
|
IN
|
NULL
|
|
SESSION_SERIAL
|
NUMBER
|
IN
|
NULL
|
|
SQL_EXEC_START
|
DATE
|
IN
|
NULL
|
|
SQL_EXEC_ID
|
NUMBER
|
IN
|
NULL
|
|
INST_ID
|
NUMBER
|
IN
|
-1
|
|
START_TIME_FILTER
|
DATE
|
IN
|
NULL
|
|
END_TIME_FILTER
|
DATE
|
IN
|
NULL
|
|
INSTANCE_ID_FILTER
|
NUMBER
|
IN
|
NULL
|
|
PARALLEL_FILTER
|
VARCHAR2
|
IN
|
NULL
|
|
EVENT_DETAIL
|
VARCHAR2
|
IN
|
'YES'
|
|
REPORT_LEVEL
|
VARCHAR2
|
IN
|
'TYPICAL'
|
|
TYPE
|
VARCHAR2
|
IN
|
'TEXT'
|
Table 7.183:
Report_sql_monitor Parameters
Report_tuning_task
is a function that displays a report based upon the tuning task data.
It returns that report as a CLOB.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TASK_NAME
|
VARCHAR2
|
IN
|
|
|
TYPE
|
VACRHAR2
|
IN
|
TYPE_TEXT
|
|
LEVEL
|
VACRHAR2
|
IN
|
LEVEL_TYPICAL
|
|
SECTION
|
VACRHAR2
|
IN
|
SECTION_ALL
|
|
OBJECT_ID
|
NUMBER
|
IN
|
NULL
|
|
RESULT_LIMIT
|
NUMBER
|
IN
|
NULL
|
|
OWNER_NAME
|
VARCHAR2
|
IN
|
NULL
|
|
EXECUTION_NAME
|
VARCHAR2
|
IN
|
NULL
|
Table 7.184:
Report_tuning_task Parameters
Reset_tuning_task
is a procedure that prepares a non-active SQL tuning task for
re-execution, i.e. resets it to starting state.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TASK_NAME
|
VARCHAR2
|
IN
|
|
Table 7.185:
Reset_tuning_task Parameter
Resume_tuning_task
is a procedure that resumes execution of a non-active SQL tuning task
that was previously interrupted, meaning stopped and in a
re-executable state. Note that one cannot resume a task to tune a
single SQL statement. This procedure is for resuming those based on
SQL Tuning Sets.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
TASK_NAME
|
VARCHAR2
|
IN
|
|
|
BASIC_FILTER
|
VARCHAR2
|
IN
|
NULL
|
Table 7.186:
Resume_tuning_task Parameters
and include the URL for the page.
