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
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

Related Topics
Autotrace
Built-in Functions
Built-in Packages
Explain Plan
DBMS_HPROF
DBMS_PROFILER
DBMS_SPM
DBMS_SPM_INTERNAL
DBMS_SQLPA
DBMS_SQLTUNE
DBMS_WORKLOAD_REPOSITORY
DBMS_XPLAN
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx