Oracle | DBMS_XPLAN

Oracle DBMS_XPLAN_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 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	XMLAGG
DBMS_SQLTUNE_INTERNAL	SPM_OBJECT	XMLTYPE
DBMS_SQLTUNE_UTIL1	SQLSET_OBJECT	XQSEQUENCE

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

      FROM dual;

      

      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