Oracle | DBMS_XPLAN

Oracle DBMS_XPLAN_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal support package for DBMS_XPLAN and Explain Plan generation.

AUTHID DEFINER

Dependencies

ADVISOR_OBJECT	DBMS_STANDARD	SQL_PLAN_ROW_TYPE
AWR_OBJECT	DBMS_SYSTEM	SQL_PLAN_TABLE_TYPE
DBMS_ADVISOR	DBMS_XPLAN	SQL_PROFILE_OBJECT
DBMS_LOB	DUAL	SYS_IXMLAGG
DBMS_SPM_INTERNAL	PLITBLM	WRI$_ADV_FINDINGS
DBMS_SQLDIAG	PRVT_ADVISOR	WRI$_ADV_OBJECTS
DBMS_SQLTUNE	PRVT_REPORT_TAGS	XMLTYPE
DBMS_SQLTUNE_INTERNAL	SPM_OBJECT	XQSEQUENCE
DBMS_SQLTUNE_UTIL1	SQLSET_OBJECT

Documented No

First Available 19c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsxplni.plb

Subprograms

COMPARE_PLANS	GET_SQL_PLAN_BASELINE_PLAN	I_REPORT_COMPARE_PLANS_TASK
GET_QA_LRG_TYPE	GET_SQL_PROFILE_PLAN	REMOVE_ALTERNATE_PLAN_ROWS

COMPARE_PLANS

Compare each plan in a list with a reference plan dbms_xplan_internal.compare_plans( xml_compare_plan_list IN CLOB, type IN VARCHAR2, level IN VARCHAR2, section IN VARCHAR2) RETURN CLOB;

TBD

GET_QA_LRG_TYPE

Undocumented dbms_xplan_internal.gt_qa_lrg_type RETURN NUMBER;

SELECT dbms_xplan_internal.get_qa_lrg_type;

      

      GET_QA_LRG_TYPE

      ---------------

                    0

GET_SQL_PLAN_BASELINE_PLAN

Undocumented dbms_xplan_internal.get_sql_plan_baseline_plan( sql_handle IN VARCHAR2, plan_name IN VARCHAR2) RETURN sys.sql_plan_table_type;

TBD

GET_SQL_PROFILE_PLAN

Undocumented dbms_xplan_internal.get_sql_profile_plan(profile_name IN VARCHAR2) RETURN sys.sql_plan_table_type;

DECLARE

       retType sys.sql_plan_table_type;

      BEGIN

        retType := dbms_xplan_internal.get_sql_profile_plan('UWSQLP');

      END;

      /

      

      PL/SQL procedure successfully completed.

I_REPORT_COMPARE_PLANS_TASK

Undocumented dbms_xplan_internal.i_report_compare_plans_task( tid IN NUMBER, wkld IN OUT dbms_sqltune_util1.task_wkldobj, exec_name IN VARCHAR2, exec_type IN VARCHAR2, obj_id IN NUMBER, level_flags IN NUMBER, plan_format IN VARCHAR2, section IN VARCHAR2, report_ref IN VARCHAR2) RETURN XMLTYPE;

TBD

REMOVE_ALTERNATE_PLAN_ROWS

Undocumented dbms_xplan_internal.remove_alternate_plan_rows( sql_plan IN OUT sys.sql_plan_table_type, format IN VARCHAR2);

TBD