Oracle DBMS_SQLTUNE_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose DBMS_SQLTUNE provides the interface for tuning SQL on demand. This INTERNAL package provides support for DBMS_SQLTUNE and other dependent objects.
AUTHID DEFINER
Data Types TYPE i_capture_statset_pair ...

TYPE i_ql_pdb_table ...

TYPE sqlmon_report_usg_t ...
Dependencies
ANYDATA DBMS_SQLTUNE_UTIL0 WRI$_ADV_ACTIONS
CDB_SQL_PROFILES DBMS_SQLTUNE_UTIL1 WRI$_ADV_DEF_PARAMETERS
DBA_ADVISOR_ACTIONS DBMS_SQLTUNE_UTIL2 WRI$_ADV_EXECUTIONS
DBA_ADVISOR_EXECUTIONS DBMS_STANDARD WRI$_ADV_FINDINGS
DBA_ADVISOR_EXEC_PARAMETERS DBMS_STATS WRI$_ADV_HDM_T
DBA_ADVISOR_FINDINGS DBMS_STATS_INTERNAL WRI$_ADV_OBJECTS
DBA_ADVISOR_OBJECTS DBMS_SYSTEM WRI$_ADV_PARAMETERS
DBA_ADVISOR_PARAMETERS DBMS_SYS_ERROR WRI$_ADV_RATIONALE
DBA_ADVISOR_RECOMMENDATIONS DBMS_UTILITY WRI$_ADV_RECOMMENDATIONS
DBA_ADVISOR_SQLSTATS DBMS_WORKLOAD_REPLAY_I WRI$_ADV_SPM_EVOLVE
DBA_ADVISOR_TASKS DBMS_XPLAN WRI$_ADV_SQLTUNE
DBA_AUTOTASK_WINDOW_CLIENTS DBMS_XPLAN_INTERNAL WRI$_ADV_SQLT_RTN_PLAN
DBA_DB_LINKS DBMS_XPLAN_TYPE_TABLE WRI$_ADV_TASKS
DBA_SQLSET_DEFINITIONS DUAL WRI$_REPT_SQLMONITOR
DBA_SQL_PROFILES PLITBLM WRI$_REPT_SQLPI
DBMS_ADVISOR PRVT_ACCESS_ADVISOR WRI$_REPT_SQLT
DBMS_ASSERT PRVT_ADVISOR WRI$_SQLMON_USAGE
DBMS_AUTO_INDEX_INTERNAL PRVT_HDM WRI$_SQLSET_BINDS
DBMS_AUTO_SQLTUNE PRVT_REPORT_TAGS WRI$_SQLSET_DEFINITIONS
DBMS_LOB PRVT_SQLADV_INFRA WRI$_SQLSET_ID_SEQ
DBMS_LOCK PRVT_SQLPA WRI$_SQLSET_MASK
DBMS_MANAGEMENT_PACKS PRVT_SQLPROF_INFRA WRI$_SQLSET_PLANS
DBMS_REPORT PRVT_SQLSET_INFRA WRI$_SQLSET_PLANS_TOCAP
DBMS_SMB PRVT_WORKLOAD WRI$_SQLSET_PLAN_LINES
DBMS_SMB_INTERNAL SQLSET_ROW WRI$_SQLSET_REFERENCES
DBMS_SPM SQL_BINDS WRI$_SQLSET_REF_ID_SEQ
DBMS_SPM_INTERNAL SQL_PLAN_ALLSTAT_ROW_TYPE WRI$_SQLSET_STATEMENTS
DBMS_SQLDIAG SQL_PLAN_ROW_TYPE WRI$_SQLSET_STATISTICS
DBMS_SQLDIAG_INTERNAL SQL_PLAN_STAT_ROW_TYPE WRI$_SQLSET_STMT_ID_SEQ
DBMS_SQLPA SQL_PLAN_TABLE_TYPE WRI$_SQLSET_STS_TOPACK
DBMS_SQLQ_INTERNAL V$SYSTEM_PARAMETER X$KEACMDN
DBMS_SQLTCB_INTERNAL V_$PARAMETER XMLSEQUENCE
DBMS_SQLTUNE WRH$_SQLTEXT XMLTYPE
DBMS_SQLTUNE_LIB    
Documented No
Exceptions
Error Code Reason
ORA-13607 The specified task or object SYS_AUTO_SQL_TUNING_TASK already exists
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvssqli.plb
{ORACLE_HOME}/rdbms/admin/prvtsqli.plb
Subprograms
ACCEPT_ALL_SQL_PROFILES I_FORMAT_LINE2 I_REPORT_COMPARE_PLANS_XML
EXEC_EMX_TUNING_TASK_CALLOUT I_FORMAT_SEPARATOR I_REPORT_SQLT_SINGLE_SQL_XML
GET_BEGIN_EXECUTION I_FORMAT_TEXT I_REPORT_SQLT_SUMMARY_XML
GET_SQLSET_USERBINDS I_FORMAT_TITLE1 I_REPORT_SQL_TABLE_XML
I_ACCEPT_SQL_PROFILE I_FORMAT_TITLE2 I_REPORT_TUNING_TASK
I_ADD_SQLSET_REFERENCE I_FORMAT_TITLE3 I_SCRIPT_TUNING_TASK
I_ADD_TASK_SQLSET_REFERENCE I_FORMAT_TITLE4 I_SET_SQLSET_PROPERTY
I_ALLOW_BIND_FLUSH I_GET_COMMAND_PIECES I_SQL_RECURSIVE
I_ALTER_SQL_PROFILE I_GET_DBLINK_TO_PRIMARY_XML I_SUB_EXECUTE
I_ASSERT_INPUT I_GET_PLAN_QUERY_TEXT I_TRACK_SQLMON_REPT_USAGE
I_CHECK_ACTIVE I_GET_REPORT_EXECSUBQ I_TRUNC_STS_TOPACK
I_CLONE_SQL_PROFILE I_IMPLEMENT_TOP_SQL_TUNING I_UNLOCK_SQLSET
I_COMBINE_CAPTURE_STATS I_INIT_CAPTURE_STATS I_UNPACK_SQLSETS_BULK
I_CREATE_AUTO_TUNING_TASK I_INSERT_SQLSET_SQLTEXT I_UPDATE_AWR_SQLTEXT_REFCOUNT
I_CREATE_SQLSET I_INSERT_STS_TOPACK I_UPDATE_CAPTURE_STATS
I_CREATE_SQL_PLAN_BASELINE I_LOAD_SQLSET_CURSOR I_UPDATE_SQLSET
I_CREATE_SQL_PROFILE I_LOAD_SQL_PROFILE I_UPDATE_SQL_PROFILE
I_CREATE_TUNING_TASK I_LOCK_SQLSET I_VALIDATE_LEVEL
I_DECR_REFC_TUNING_TASK I_MOVE_DELTA_COLUMNS I_VALIDATE_PROCESS_ACTION
I_DELETE_SQLSET I_OPEN_IMPL_PROFILE_CURSOR I_VALIDATE_TUNING_PARAMETER
I_DROP_SQLSET I_OPEN_SCRIPT_CURSOR RETRIEVE_AUTOTUNE_INFO_XML
I_DROP_SQL_PROFILE I_PARSE_SCRIPT_REC_TYPES SQLDET_FINDSQL_XML
I_DROP_USER_SQLSETS I_PROCESS_SQL SQLMON_PARSE_REPORT_REF
I_DUMP_CAPTURE_STATS I_QUALIFIED_NAME TEST_KSD_TRACE
I_FORMAT_ERROR I_REMOVE_SQLSET_REFERENCE TEST_PROCESS_SQLSET
I_FORMAT_LINE1 I_REPORT_AUTO_SUMMARY_XML  
 
ACCEPT_ALL_SQL_PROFILES
Undocumented dbms_sqltune_internal.accept_all_sql_profiles(
task_name       IN VARCHAR2,
category        IN VARCHAR2,
replace         IN BOOLEAN,
force_match     IN BOOLEAN,
profile_type    IN VARCHAR2,
autotune_period IN NUMBER,
execution_name  IN VARCHAR2,
task_owner      IN VARCHAR2,
description     IN VARCHAR2,
profile_creator IN VARCHAR2);
TBD
 
EXEC_EMX_TUNING_TASK_CALLOUT
Undocumented dbms_sqltune_internal.exec_emx_tuning_task_callout(task_id IN NUMBER);
TBD
 
GET_BEGIN_EXECUTION
Undocumented dbms_sqltune_internal.get_begin_execution(
task_id     IN NUMBER,
end_ename   IN VARCHAR2,
time_period IN NUMBER)
RETURN VARCHAR2;
TBD
 
GET_SQLSET_USERBINDS
Undocumented dbms_sqltune_internal.get_sqlset_userbinds(
sql_seq   IN NUMBER,
plan_hash IN NUMBER)
RETURN sys.sql_binds;
TBD
 
I_ACCEPT_SQL_PROFILE
Undocumented dbms_sqltune_internal.i_accept_sql_profile(
task_name       IN VARCHAR2,
task_owner      IN VARCHAR2,
object_id       IN NUMBER,
name            IN VARCHAR2,
description     IN VARCHAR2,
category        IN VARCHAR2,
replace         IN BOOLEAN,
force_match     IN BOOLEAN,
is_patch        IN BOOLEAN,
profile_type    IN VARCHAR2,
profile_creator IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
I_ADD_SQLSET_REFERENCE
Undocumented dbms_sqltune_internal.i_add_sqlset_reference(
sqlset_name  IN VARCHAR2,
sqlset_owner IN VARCHAR2,
ref_owner    IN VARCHAR2,
description  IN VARCHAR2)
RETURN NUMBER;
TBD
 
I_ADD_TASK_SQLSET_REFERENCE
Undocumented dbms_sqltune_internal.i_add_task_sqlset_reference(
sqlset_name   IN  VARCHAR2,
sqlset_owner  IN  VARCHAR2,
advisor_name  IN  VARCHAR2,
task_name     IN  VARCHAR2,
task_owner_id IN  NUMBER,
ref_id        OUT NUMBER);
TBD
 
I_ALLOW_BIND_FLUSH
Undocumented dbms_sqltune_internal.i_allow_bind_flush RETURN NUMBER;
SELECT dbms_sqltune_internal.i_allow_bind_flush
FROM dual;

I_ALLOW_BIND_FLUSH
------------------
                 1
 
I_ALTER_SQL_PROFILE
Undocumented dbms_sqltune_internal.i_alter_sql_profile(
name           IN VARCHAR2,
attribute_name IN VARCHAR2,
value          IN VARCHAR2,
is_patch       IN BOOLEAN);
TBD
 
I_ASSERT_INPUT
Undocumented dbms_sqltune_internal.i_assert_input(
type       IN NUMBER,
str        IN VARCHAR2,
error_code IN NUMBER)
RETURN VARCHAR2;
TBD
 
I_CHECK_ACTIVE
Undocumented dbms_sqltune_internal.i_check_active(
sqlset_name  IN VARCHAR2,
sqlset_owner IN VARCHAR2);
TBD
 
I_CLONE_SQL_PROFILE
Undocumented dbms_sqltune_internal.i_clone_sql_profile(
from_name   IN VARCHAR2,
to_name     IN VARCHAR2,
to_category IN VARCHAR2,
is_patch    IN BOOLEAN);
TBD
 
I_COMBINE_CAPTURE_STATS
Undocumented dbms_sqltune_internal.i_combine_capture_stats(
stats_src IN     sys.dbms_sqltune_internal.i_capture_statset_pair,
stats_dst IN OUT sys.dbms_sqltune_internal.i_capture_statset_pair);
TBD
 
I_CREATE_AUTO_TUNING_TASK
Undocumented but executed by $ORACLE_HOME/rdbms/admin/ sqltacrt.sql dbms_sqltune_internal.i_create_auto_tuning_task;
exec dbms_sqltune_internal.i_create_auto_tuning_task;
BEGIN dbms_sqltune_internal.i_create_auto_tuning_task; END;
*
ERROR at line 1:
ORA-13607: The specified task or object SYS_AUTO_SQL_TUNING_TASK already exists
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14353
ORA-06512: at "SYS.PRVT_ADVISOR", line 6086
ORA-06512: at "SYS.PRVT_ADVISOR", line 1843
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_ADVISOR", line 7135
ORA-06512: at "SYS.PRVT_ADVISOR", line 1616
ORA-06512: at "SYS.PRVT_ADVISOR", line 6048
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 14265
ORA-06512: at line 1
-- the following code can be found in $ORACLE_HOME/rdbms/admin/execsqlt.sql

Rem Create the automatic SQL Tuning and automatic SPM evolve tasks
Rem If the tasks already exist (catproc is being re-run), do not error.

BEGIN
  sys.dbms_sqltune_internal.i_create_auto_tuning_task;
EXCEPTION
  WHEN OTHERS THEN
    IF (sqlcode = -13607        -- task already exists
    OR  sqlcode = -65040) THEN  -- operation not allowed inside PDB(lrg 7000350)
    NULL;
  ELSE
    RAISE;
  END IF;
END;
/
 
I_CREATE_SQLSET
Undocumented dbms_sqltune_internal.i_create_sqlset(
sqlset_name  IN OUT VARCHAR2,
sqlset_owner IN     VARCHAR2,
description  IN     VARCHAR2,
commit_after IN     BOOLEAN);
TBD
 
I_CREATE_SQL_PLAN_BASELINE
Undocumented dbms_sqltune_internal.i_create_sql_plan_baseline(
task_name        IN VARCHAR2,
object_id        IN NUMBER,
plan_hash_value  IN NUMBER,
owner_name       IN VARCHAR2,
baseline_creator IN VARCHAR2);
TBD
 
I_CREATE_SQL_PROFILE
Undocumented

Overload 1
dbms_sqltune_internal.i_create_sql_profile(
sql_text    IN CLOB,
profile_xml IN CLOB,
name        IN VARCHAR2,
description IN VARCHAR2,
category    IN VARCHAR2,
creator     IN VARCHAR2,
validate    IN BOOLEAN,
replace     IN BOOLEAN,
force_match IN BOOLEAN,
type        IN VARCHAR2,
is_patch    IN BOOLEAN,
plan_rows   IN sys.sql_plan_table_type)
RETURN VARCHAR2;
TBD
Overload 2 dbms_sqltune_internal.i_create_sql_profile(
hash_value  IN NUMBER,
address     IN RAW,
profile_xml IN CLOB,
name        IN VARCHAR2,
description IN VARCHAR2,
category    IN VARCHAR2,
creator     IN VARCHAR2,
validate    IN BOOLEAN,
replace     IN BOOLEAN,
force_match IN BOOLEAN,
is_patch    IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
I_CREATE_TUNING_TASK
Undocumented

Overload 1
dbms_sqltune_internal.i_create_tuning_task(
sql_rec       IN sys.sqlset_row,
scope         IN VARCHAR2,
tlimit        IN NUMBER,
taskname      IN VARCHAR2,
descrp        IN VARCHAR2,
adv_name      IN VARCHAR2,
task_owner_id IN NUMBER)
RETURN VARCHAR2;
TBD
Overload 2 dbms_sqltune_internal.i_create_tuning_task(
sqlsetowner   IN VARCHAR2,
basicfilter   IN VARCHAR2,
objfilter     IN VARCHAR2,
plnfilter     IN VARCHAR2,
rank1         IN VARCHAR2,
rank2         IN VARCHAR2,
rank3         IN VARCHAR2,
rsltperc      IN NUMBER,
rsltlimit     IN NUMBER,
scope         IN VARCHAR2,
tlimit        IN NUMBER,
taskname      IN VARCHAR2,
descrp        IN VARCHAR2,
adv_name      IN VARCHAR2,
task_owner_id IN NUMBER)
RETURN VARCHAR2;
TBD
Overload 3 dbms_sqltune_internal.i_create_tuning_task(
spa_task_id       IN NUMBER,
spa_compare_exec  IN VARCHAR2,
spa_exec_one      IN VARCHAR2,
spa_exec_one_type IN NUMBER,
spa_env_obj_id    IN NUMBER,
spa_sql_obj_id    IN NUMBER,
spa_sqlset_name   IN VARCHAR2,
spa_sqlset_owner  IN VARCHAR2,
basic_filter      IN VARCHAR2,
scope             IN VARCHAR2,
tlimit            IN NUMBER,
taskname          IN VARCHAR2,
descrp            IN VARCHAR2,
adv_name          IN VARCHAR2,
task_owner_id     IN NUMBER)
RETURN VARCHAR2;
TBD
 
I_DECR_REFC_TUNING_TASK
Undocumented dbms_sqltune_internal.i_decr_refc_tuning_task(
task_id   IN NUMBER,
exec_name IN VARCHAR2);
TBD
 
I_DELETE_SQLSET
Undocumented dbms_sqltune_internal.i_delete_sqlset(
sqlset_name  IN VARCHAR2,
sqlset_owner IN VARCHAR2,
sqlset_id    IN NUMBER,
sts_cursor   IN REF CURSOR)
RETURN NUMBER;
TBD
 
I_DROP_SQLSET
Undocumented dbms_sqltune_internal.i_drop_sqlset(
sqlset_name       IN VARCHAR2,
sqlset_owner      IN VARCHAR2,
commit_after_drop IN BOOLEAN)
RETURN NUMBER
TBD
 
I_DROP_SQL_PROFILE
Undocumented dbms_sqltune_internal.i_drop_sql_profile(
name     IN VARCHAR2,
ignore   IN BOOLEAN,
is_patch IN BOOLEAN);
TBD
 
I_DROP_USER_SQLSETS
Undocumented dbms_sqltune_internal.i_drop_user_sqlsets(user_name IN VARCHAR2);
exec dbms_sqltune_internal.i_drop_user_sqlsets('C##UWCLASS');

PL/SQL procedure successfully completed.
 
I_DUMP_CAPTURE_STATS
Undocumented dbms_sqltune_internal.i_dump_capture_stats(
statset_ctx IN sys.dbms_sqltune_internal.i_capture_statset_pair,
loop_number IN NUMBER,
TBD
 
I_FORMAT_ERROR
Undocumented dbms_sqltune_internal.i_format_error(
report_res IN OUT CLOB,
error_msg  IN     VARCHAR2,
new_line   IN     BOOLEAN);
TBD
 
I_FORMAT_LINE1
Undocumented dbms_sqltune_internal.i_format_line1(
report_res IN OUT CLOB,
line       IN     VARCHAR2);
TBD
 
I_FORMAT_LINE2
Undocumented dbms_sqltune_internal.i_format_line2(
report_res IN OUT CLOB,
line       IN     VARCHAR2,
margin     IN     NUMBER);
TBD
 
I_FORMAT_SEPARATOR
Undocumented dbms_sqltune_internal.i_format_separator(
report_res IN OUT CLOB,
margin     IN     NUMBER,
sep_len    IN     NUMBER,
sep_chr    IN     VARCHAR2);
TBD
 
I_FORMAT_TEXT
Undocumented dbms_sqltune_internal.i_format_text(
report_res IN OUT CLOB,
text       IN     CLOB,
margin     IN     NUMBER,
first_line IN     BOOLEAN);
TBD
 
I_FORMAT_TITLE1
Undocumented dbms_sqltune_internal.i_format_title1(
report_res   IN OUT CLOB,
title        IN     VARCHAR2,
new_line     IN     BOOLEAN,
align_center IN     BOOLEAN);
TBD
 
I_FORMAT_TITLE2
Undocumented dbms_sqltune_internal.i_format_title2(
report_res IN OUT CLOB,
title      IN     VARCHAR2,
pos        IN     NUMBER);
TBD
 
I_FORMAT_TITLE3
Undocumented dbms_sqltune_internal.i_format_title3(
report_res IN OUT CLOB,
title      IN     VARCHAR2,
pos        IN     NUMBER,
text       IN     VARCHAR2);
TBD
 
I_FORMAT_TITLE4
Undocumented dbms_sqltune_internal.i_format_title4(
report_res IN OUT CLOB,
title      IN     VARCHAR2,
margin     IN     NUMBER);
TBD
 
I_GET_COMMAND_PIECES
Undocumented dbms_sqltune_internal.i_get_command_pieces(
owner_name          IN     VARCHAR2,
cmd                 IN     VARCHAR2,
att1                IN     VARCHAR2,
att2                IN     VARCHAR2,
att3                IN     VARCHAR2,
att4                IN     VARCHAR2,
att5                IN     VARCHAR2,
att6                IN     VARCHAR2,
level_flags         IN     NUMBER,
first_piece         IN OUT VARCHAR2,
second_piece        IN OUT VARCHAR2,
profile_force_match IN     NUMBER);
TBD
 
I_GET_DBLINK_TO_PRIMARY_XML
Undocumented dbms_sqltune_internal.i_get_dblink_to_primary_xml RETURN sys.xmltype;
TBD
 
I_GET_PLAN_QUERY_TEXT
Undocumented dbms_sqltune_internal.i_get_plan_query_text(
parse_mode         IN VARCHAR2,
attribute_selected IN BINARY_INTEGER,
awr_view           IN VARCHAR2,
RETURN VARCHAR2;
TBD
 
I_GET_REPORT_EXECSUBQ
Undocumented dbms_sqltune_internal.i_get_report_execsubq(flags IN BINARY_INTEGER) RETURN VARCHAR2;
TBD
 
I_IMPLEMENT_TOP_SQL_TUNING
Undocumented dbms_sqltune_internal.i_implement_top_sql_tuning(
task_id          IN NUMBER,
execution_params IN sys.dbms_advisor.arglist);
TBD
 
I_INIT_CAPTURE_STATS
Undocumented dbms_sqltune_internal.i_init_capture_stats(
statset_ctx IN OUT sys.dbms_sqltune_internal.i_capture_statset_pair,
debug       IN     BOOLEAN);
TBD
 
I_INSERT_SQLSET_SQLTEXT
Undocumented dbms_sqltune_internal.i_insert_sqlset_sqltext(
sql_text IN CLOB,
sql_id   IN VARCHAR2,
cmd_type IN NUMBER,
con_dbid IN NUMBER);
TBD
 
I_INSERT_STS_TOPACK
Undocumented dbms_sqltune_internal.i_insert_sts_topack(sqlset_id_cur IN REF CURSOR) RETURN NUMBER;
TBD
 
I_LOAD_SQLSET_CURSOR
Undocumented dbms_sqltune_internal.i_load_sql_profile(
sqlset_id          IN     NUMBER,
load_cur           IN     REF CURSOR,
attribute_selected IN     BINARY_INTEGER,
load_action        IN     BINARY_INTEGER,
load_flags         IN     BINARY_INTEGER,
update_option      IN     VARCHAR2,
ignore_null        IN     BOOLEAN,
commit_rows        IN     BINARY_INTEGER,
capture_stats      IN OUT sys.dbms_sqltune_internal.i_capture_stat_context,
filter_recursive   IN     BOOLEAN)
RETURN NUMBER;
TBD
 
I_LOAD_SQL_PROFILE
Undocumented dbms_sqltune_internal.i_load_sqlset_cursor(
sql_stmt    IN sys.sqlset_row,
profile_xml IN CLOB,
name        IN VARCHAR2,
description IN VARCHAR2,
category    IN VARCHAR2,
creator     IN VARCHAR2,
task_id     IN BINARY_INTEGER,
exec_name   IN VARCHAR2,
object_id   IN BINARY_INTEGER,
finding_id  IN BINARY_INTEGER,
rec_id      IN BINARY_INTEGER,
outline     IN CLOB,
plan_hash   IN NUMBER,
verified    IN BINARY_INTEGER,
validate    IN BOOLEAN,
replace     IN BOOLEAN,
force_match IN BOOLEAN,
is_patch    IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
I_LOCK_SQLSET
Undocumented dbms_sqltune_internal.i_lock_sqlset(
name         IN  VARCHAR2,
sqlset_owner IN  VARCHAR2,
lock_handle  OUT VARCHAR2);
TBD
 
I_MOVE_DELTA_COLUMNS
Undocumented dbms_sqltune_internal.i_move_delta_columns(sts_id IN NUMBER);
TBD
 
I_OPEN_IMPL_PROFILE_CURSOR
Undocumented dbms_sqltune_internal.i_open_impl_profile_cursor(
tid       IN NUMBER,
exec_name IN VARCHAR2);
RETURN REF CURSOR;
TBD
 
I_OPEN_SCRIPT_CURSOR
Undocumented dbms_sqltune_internal.i_open_script_cursor(
tid       IN NUMBER,
exec_name IN VARCHAR2,
rec_flags IN BINARY_INTEGER,
object_id IN NUMBER,
stmt_cnt  IN NUMBER,
rec_id    IN NUMBER)
RETURN REF CURSOR;
TBD
 
I_PARSE_SCRIPT_REC_TYPES
Undocumented dbms_sqltune_internal.i_parse_script_rec_types(rec_type IN VARCHAR2)
RETURN BINARY_INTEGER;
TBD
 
I_PROCESS_SQL
Undocumented dbms_sqltune_internal.i_process_sql(
stmt         IN OUT sys.sqlset_row,
exec_userid  IN     NUMBER,
action       IN     VARCHAR2,
time_limit   IN     BINARY_INTEGER,
ctrl_options IN     CLOB,
extra_result OUT    CLOB,
err_code     OUT    NUMBER,
err_mesg     OUT    VARCHAR2);
TBD
 
I_QUALIFIED_NAME
Undocumented dbms_sqltune_internal.i_qualified_name(
object_name  IN VARCHAR2,
schema_owner IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
I_REMOVE_SQLSET_REFERENCE
Undocumented dbms_sqltune_internal.i_remove_sqlset_reference(
sqlset_name  IN VARCHAR2,
sqlset_owner IN VARCHAR2,
ref_owner    IN VARCHAR2,
ref_id       IN NUMBER,
force        IN NUMBER);
TBD
 
I_REPORT_AUTO_SUMMARY_XML
Undocumented dbms_sqltune_internal.i_report_auto_summary_xml(
report_reference IN VARCHAR2,
tid              IN NUMBER,
begin_exec       IN VARCHAR2,
end_exec         IN VARCHAR2,
section          IN VARCHAR2)
RETURN sys.xmltype;
TBD
 
I_REPORT_COMPARE_PLANS_XML
Undocumented dbms_sqltune_internal.i_report_compare_plans_xml(
report_reference IN VARCHAR2,
tid              IN NUMBER,
ename            IN VARCHAR2,
objid            IN NUMBER)
RETURN sys.xmltype;
TBD
 
I_REPORT_SQLT_SINGLE_SQL_XML
Undocumented dbms_sqltune_internal.i_report_sqlt_single_sql_xml(
report_reference IN VARCHAR2,
task_name        IN VARCHAR2,
ename            IN VARCHAR2,
objid            IN NUMBER,
owner_id         IN NUMBER,
plan_group       IN VARCHAR2,
plan_type        IN VARCHAR2,
report_level     IN VARCHAR2)
RETURN sys.xmltype;
TBD
 
I_REPORT_SQLT_SUMMARY_XML
Undocumented dbms_sqltune_internal.i_report_sqlt_summary_xml(
report_reference IN VARCHAR2,
tid              IN NUMBER,
exec_name        IN VARCHAR2)
RETURN sys.xmltype;
TBD
 
I_REPORT_SQL_TABLE_XML
Undocumented dbms_sqltune_internal.i_report_sql_table_xml(
report_reference  IN VARCHAR2,
tid               IN NUMBER,
begin_ename       IN VARCHAR2,
end_ename         IN VARCHAR2,
finding_filter    IN VARCHAR2,
orderby           IN VARCHAR2,
in_order          IN VARCHAR2,
result_limit      IN NUMBER,
starting_with     IN NUMBER,
stats_hash_filter IN NUMBER,
index_hash_filter IN NUMBER,
is_em_express     IN BOOLEAN)
RETURN sys.xmltype;
TBD
 
I_REPORT_TUNING_TASK
Undocumented dbms_sqltune_internal.i_report_tuning_task(
tid          IN NUMBER,
task_name    IN VARCHAR2,
begin_exec   IN VARCHAR2,
end_exec     IN VARCHAR2,
obj_id       IN NUMBER,
result_limit IN NUMBER,
type         IN VARCHAR2,
level        IN VARCHAR2,
section      IN VARCHAR2,
flags        IN NUMBER,
owner_name   IN VARCHAR2)
RETURN CLOB;
TBD
 
I_SCRIPT_TUNING_TASK
Undocumented dbms_sqltune_internal.i_script_tuning_task(
task_id      IN     NUMBER,
task_name    IN     VARCHAR2,
owner_name   IN     VARCHAR2,
exec_name    IN     VARCHAR2,
rec_type     IN     VARCHAR2,
object_id    IN     NUMBER,
result_limit IN     NUMBER,
script       IN OUT CLOB);
TBD
 
I_SET_SQLSET_PROPERTY
Undocumented dbms_sqltune_internal.i_set_sqlset_property(
sqlset_name  IN VARCHAR2,
sqlset_owner IN VARCHAR2,
property     IN NUMBER);
TBD
 
I_SQL_RECURSIVE
Undocumented dbms_sqltune_internal.i_sql_recursive(optimizer_env IN RAW) RETURN BOOLEAN;
TBD
 
I_SUB_EXECUTE
Undocumented dbms_sqltune_internal.i_sub_execute(
TBD
 
I_TRACK_SQLMON_REPT_USAGE
Undocumented dbms_sqltune_internal.i_track_sqlmon_rept_usage(
report_caller    IN VARCHAR2,
cached_usg_stats IN sys.sqltune_internal.sqlmon_report_usg_t);
TBD
 
I_TRUNC_STS_TOPACK
Undocumented dbms_sqltune_internal.i_trunc_sts_topack;
exec dbms_sqltune_internal.i_trunc_sts_topack;

PL/SQL procedure successfully completed.
 
I_UNLOCK_SQLSET
Undocumented dbms_sqltune_internal.i_unlock_sqlset(lock_handle IN VARCHAR2);
TBD
 
I_UNPACK_SQLSETS_BULK
Undocumented dbms_sqltune_internal.i_unpack_sqlsets_bulk(
qualified_stgtab_name IN VARCHAR2,
vsn                   IN NUMBER)
RETURN NUMBER;
TBD
 
I_UPDATE_AWR_SQLTEXT_REFCOUNT
Undocumented dbms_sqltune_internal.i_update_awr_sqltext_refcount(
pdbid_set       IN sys.dbms_sqltune_internal.i_ql_pdb_table,
refcount_action IN BOOLEAN);
TBD
 
I_UPDATE_CAPTURE_STATS
Undocumented dbms_sqltune_internal.i_update_capture_stats(
statset_ctx IN OUT sys.dbms_sqltune_internal.i_capture_statset_pair,
debug       IN     BOOLEAN);
TBD
 
I_UPDATE_SQLSET
Undocumented

Overload 1
dbms_sqltune_internal.i_update_sqlset(
name            IN VARCHAR2,
sqlset_owner    IN VARCHAR2,
sql_id          IN VARCHAR2,
plan_hash_value IN NUMBER,
attribute_name  IN VARCHAR2,
attribute_value IN VARCHAR2);
TBD
Overload 2 dbms_sqltune_internal.i_update_sqlset(
name            IN VARCHAR2,
sqlset_owner    IN VARCHAR2,
sql_id          IN VARCHAR2,
plan_hash_value IN NUMBER,
attribute_name  IN VARCHAR2,
attribute_value IN NUMBER);
TBD
 
I_UPDATE_SQL_PROFILE
Undocumented dbms_sqltune_internal.i_update_sql_profile(
name        IN VARCHAR2,
profile_xml IN CLOB,
validate    IN BOOLEAN,
is_patch    IN BOOLEAN);
TBD
 
I_VALIDATE_LEVEL
Undocumented dbms_sqltune_internal.i_validate_level(
level_text  IN  VARCHAR2,
level_flags OUT NUMBER,
plan_format OUT VARCHAR2,
plan_flags  OUT NUMBER,
exec_type   IN  VARCHAR2,
error_code  OUT VARCHAR2);
TBD
 
I_VALIDATE_PROCESS_ACTION
Undocumented dbms_sqltune_internal.i_validate_process_action(
actions     IN  VARCHAR2,
action_flag OUT BINARY_INTEGER);
TBD
 
I_VALIDATE_TUNING_PARAMETER
Undocumented dbms_sqltune_internal.i_validate_tuning_parameter(
name  IN VARCHAR2,
value IN VARCHAR2);
TBD
 
RETRIEVE_AUTOTUNE_INFO_XML
Undocumented dbms_sqltune_internal.retrieve_autotune_info_xml RETURN sys.xmltype;
SELECT dbms_sqltune_internal.retrieve_autotune_info_xml
FROM dual;

RETRIEVE_AUTOTUNE_INFO_XML
-----------------------------------------------------------------------------------------<info_group name="task_info"><info name="status">ENABLED</info><info name="hidden_status"></info><info name="autoimpl_status">DISABLED</info><info name="persql_time_limit">1200</inf
o><info name="exec_max_profiles">20</info><info name="auto_max_profiles">10000</info></info_group>
 
SQLDET_FINDSQL_XML
Undocumented dbms_sqltune_internal.sqldet_findsql_xml(
p_sql_id   IN VARCHAR2,
p_dbid     IN NUMBER,
p_con_dbid IN NUMBER,
p_max_time IN TIMESTAMP)
RETURN sys.xmltype;
TBD
 
SQLMON_PARSE_REPORT_REF
Undocumented dbms_sqltune_internal.sqlmon_parse_report_ref(
report_reference    IN  VARCHAR2,
with_summary        IN  BOOLEAN,
component_name      OUT VARCHAR2,
report_name         OUT VARCHAR2,
sql_id              OUT VARCHAR2,
session_id          OUT NUMBER,
session_serial      OUT NUMBER,
sql_exec_start      OUT DATE,
sql_exec_id         OUT NUMBER,
sql_plan_hash_value OUT NUMBER,
start_time_filter   OUT DATE,
end_time_filter     OUT DATE,
inst_id             OUT NUMBER,
instance_id_filter  OUT NUMBER,
parallel_filter     OUT VARCHAR2,
plan_line_filter    OUT NUMBER,
event_detail        OUT VARCHAR2,
bucket_max_count    OUT NUMBER,
bucket_interval     OUT NUMBER,
report_level        OUT VARCHAR2,
auto_refresh        OUT NUMBER,
report_base_path    OUT VARCHAR2,
active_since_sec    OUT NUMBER,
active_since_date   OUT DATE,
active_before_date  OUT DATE,
last_refresh_time   OUT DATE,
dbop_name           OUT VARCHAR2,
dbop_exec_id        OUT NUMBER,
max_sqltext_length  OUT NUMBER,
top_n_count         OUT NUMBER,
top_n_rankby        OUT VARCHAR2,
con_name            OUT VARCHAR2,
top_n_detail_count  OUT NUMBER,
report_id           OUT NUMBER);
TBD
 
TEST_KSD_TRACE
Undocumented dbms_sqltune_internal.test_ksd_trace(
flags   IN NUMBER,
message IN VARCHAR2);
TBD
 
TEST_PROCESS_SQLSET
Undocumented dbms_sqltune_internal.test_process_sqlset(
sqlset_name   IN  VARCHAR2,
wrkspc_name   IN  VARCHAR2,
exec_userid   IN  NUMBER,
action        IN  VARCHAR2,
time_limit    IN  BINARY_INTEGER,
ctrl_options  IN  CLOB,
basic_filter  IN  VARCHAR2,
rank          IN  VARCHAR2,
all_sql       IN  BOOLEAN,
commit_rows   IN  BINARY_INTEGER,
sqlset_owner  IN  VARCHAR2,
error_code    OUT NUMBER,
error_message OUT VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_ADVISOR
DBMS_AUTO_SQLTUNE
DBMS_SQLDIAG
DBMS_SQLPA
DBMS_SQLSET
DBMS_SQLTUNE
DBMS_SQLTUNE_UTIL0
DBMS_SQLTUNE_UTIL1
DBMS_SQLTUNE_UTIL2
DBMS_XPLAN
PRVT_SQLPROF_INFRA
PRVT_SQLSET_INFRA
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx