Oracle DBMS_XPLAN_INTERNAL
Version 19c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Internal support package for DBMS_XPLAN.

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
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 (new 19c)
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 (new 19c)
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 (new 19c)
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 (new 19c)
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 (new 19c)
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 (new 19c)
Undocumented dbms_xplan_internal.remove_alternate_plan_rows(
sql_plan IN OUT sys.sql_plan_table_type,
format   IN     VARCHAR2);
TBD

Related Topics
Autotrace
AWR
Built-in Functions
Built-in Packages
Explain Plan
DBMS_HPROF
DBMS_PROFILER
DBMS_SPM
DBMS_SPM_INTERNAL
DBMS_SQLPA
DBMS_SQLTUNE
DBMS_XPLAN
What's New In 19c
What's New In 20c

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