Oracle | DBMS_SQLTUNE

Oracle DBMS_SQLTUNE_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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 SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_SQLTUNE_INTERNAL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_SQLTUNE_INTERNAL' ORDER BY 1;

Returns 108 objects

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_TEXT	I_REMOVE_SQLSET_REFERENCE
EXEC_EMX_TUNING_TASK_CALLOUT	I_FORMAT_TITLE1	I_REPORT_AUTO_SUMMARY_XML
GET_BEGIN_EXECUTION	I_FORMAT_TITLE2	I_REPORT_COMPARE_PLANS_XML
GET_SQLSET_USERBINDS	I_FORMAT_TITLE3	I_REPORT_SQLT_SINGLE_SQL_XML
I_ACCEPT_SQL_PROFILE	I_FORMAT_TITLE4	I_REPORT_SQLT_SUMMARY_XML
I_ADD_SQLSET_REFERENCE	I_GET_COMMAND_PIECES	I_REPORT_SQL_TABLE_XML
I_ADD_TASK_SQLSET_REFERENCE	I_GET_DBLINK_TO_PRIMARY_XML	I_REPORT_TUNING_TASK
I_ALLOW_BIND_FLUSH	I_GET_HASH_NAMES	I_SCRIPT_TUNING_TASK
I_ALTER_SQL_PROFILE	I_GET_HASH_VALUES	I_SET_SQLSET_PROPERTY
I_ASSERT_INPUT	I_GET_PLAN_QUERY_TEXT	I_SQL_RECURSIVE
I_CHECK_ACTIVE	I_GET_PLAN_XML	I_SUB_EXECUTE
I_CLONE_SQL_PROFILE	I_GET_REPORT_EXECSUBQ	I_TRACK_SQLMON_REPT_USAGE
I_COMBINE_CAPTURE_STATS	I_GET_SQL_METADATA	I_TRUNC_STS_TOPACK
I_CREATE_AUTO_TUNING_TASK	I_GET_SQL_TEXT	I_UNLOCK_SQLSET
I_CREATE_SQLSET	I_IMPLEMENT_TOP_SQL_TUNING	I_UNPACK_SQLSETS_BULK
I_CREATE_SQL_PLAN_BASELINE	I_INCREASE_SQLTEXT_TAB_QUOTA	I_UPDATE_AWR_SQLTEXT_REFCOUNT
I_CREATE_SQL_PROFILE	I_INIT_CAPTURE_STATS	I_UPDATE_CAPTURE_STATS
I_CREATE_TUNING_TASK	I_INSERT_STS_TOPACK	I_UPDATE_SQLSET
I_DECR_REFC_TUNING_TASK	I_LOAD_SQLSET_CURSOR	I_UPDATE_SQLSET_EMS
I_DELETE_SQLSET	I_LOAD_SQL_PROFILE	I_UPDATE_SQL_PROFILE
I_DROP_SQLSET	I_LOCK_SQLSET	I_VALIDATE_LEVEL
I_DROP_SQL_PROFILE	I_MOVE_DELTA_COLUMNS	I_VALIDATE_PROCESS_ACTION
I_DROP_USER_SQLSETS	I_NAMED_EVENT_SET	I_VALIDATE_TUNING_PARAMETER
I_DUMP_CAPTURE_STATS	I_OPEN_IMPL_PROFILE_CURSOR	RETRIEVE_AUTOTUNE_INFO_XML
I_FORMAT_ERROR	I_OPEN_SCRIPT_CURSOR	SQLDET_FINDSQL_XML
I_FORMAT_LINE1	I_PARSE_SCRIPT_REC_TYPES	SQLMON_PARSE_REPORT_REF
I_FORMAT_LINE2	I_PROCESS_SQL	TEST_KSD_TRACE
I_FORMAT_SEPARATOR	I_QUALIFIED_NAME	TEST_PROCESS_SQLSET

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;

      

      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;

          
      *

      ORA-13607: The specified task or object SYS_AUTO_SQL_TUNING_TASK already exists

-- 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 (new 23ai overload)

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

Overload 4 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_HASH_NAMES (new 23ai)

Undocumented dbms_sqltune_internal.i_get_hash_names( session_id IN NUMBER, session_serial IN NUMBER, instance_id IN NUMBER, module_hash IN NUMBER, action_hash IN NUMBER, module_name OUT VARCHAR2, action_name OUT VARCHAR2, service_name OUT VARCHAR2);

TBD

I_GET_HASH_VALUES (new 23ai)

Undocumented dbms_sqltune_internal.i_get_hash_values( module_name IN VARCHAR2, action_name IN VARCHAR2, service_name IN VARCHAR2, module_hash OUT NUMBER, action_hash OUT NUMBER, service_hash OUT NUMBER);

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_PLAN_XML (new 23ai)

Undocumented dbms_sqltune_internal.i_get_plan_xml( i_sql_id IN VARCHAR2, i_inst_id IN NUMBER, i_plan_hash IN NUMBER, i_child_number IN NUMBER, i_child_address IN VARCHAR2, i_plan_format IN VARCHAR2, i_con_id IN NUMBER, i_full_sqltext IN CLOB, i_parsing_user_id IN NUMBER, i_parsing_schema_id IN NUMBER) RETURN sys.xmlType;

TBD

I_GET_REPORT_EXECSUBQ

Undocumented dbms_sqltune_internal.i_get_report_execsubq(flags IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

I_GET_SQL_METADATA (new 23ai)

Undocumented dbms_sqltune_internal.i_get_sql_metadata( sql_id IN VARCHAR2, inst_id_low IN NUMBER, inst_id_high IN NUMBER, child_number IN NUMBER, child_address IN OUT VARCHAR2, con_id IN NUMBER, full_sqltext IN OUT CLOB, parsing_user_id OUT NUMBER, parsing_schema_id OUT NUMBER, internal_test IN NUMBER);

TBD

I_GET_SQL_TEXT (new 23ai)

Undocumented dbms_sqltune_internal.i_get_sql_text( sqlid IN VARCHAR2, conid IN NUMBER, sqltext IN OUT VARCHAR2, isfulltext IN OUT CHAR);

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_INCREASE_SQLTEXT_TAB_QUOTA

Undocumented dbms_sqltune_internal.i_increase_sqltext_tab_quota(stmt_count IN NUMBER) RETURN NUMBER;

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_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_NAMED_EVENT_SET (new 23ai)

Undocumented dbms_sqltune_internal.i_named_event_set( name IN VARCHAR2, level IN BINARY_INTEGER) RETURN BOOLEAN;

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 (new 23ai overload)

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

Overload 3 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 CLOB);

TBD

I_UPDATE_SQLSET_EMS (new 23ai overload)

Undocumented dbms_sqltune_internal.i_update_sqlset_ems( name IN VARCHAR2, sqlset_owner IN VARCHAR2);

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;

      

      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