Oracle | DBMS_SQLTUNE

Oracle DBMS_SQLTUNE_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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