Oracle DBMS_SWAT_XML
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
SQL Workload Analysis & Tuning
Purpose TBD
AUTHID DEFINER
Dependencies
DBMS_SWAT_MM_UTILS SWAT_MM_JOURNAL$ XMLTYPE
DBMS_XMLDOM    
Documented No
First Available 23ai
Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvsswatxml.plb
{ORACLE_HOME}/rdbms/admin/prvtswatxml.plb
Subprograms
 
RECORD_XML_MVLOG_DROP (new 23ai)
Undocumented dbms_swat_xml.record_xml_mvlog_drop(
mvlog_owner      IN VARCHAR2,
mvlog_table_name IN VARCHAR2);
TBD
 
RECORD_XML_MV_DDL (new 23ai)
Undocumented dbms_swat_xml.record_xml_mv_ddl(
mv_owner    IN VARCHAR2,
mvname      IN VARCHAR2,
auto_mv_ddl IN CLOB,
ddllen      IN NUMBER);
TBD
 
RECORD_XML_MV_DROP (new 23ai)
Undocumented dbms_swat_xml.record_xml_mv_drop(
mv_owner             IN VARCHAR2,
mvname               IN VARCHAR2,
reason               IN VARCHAR2,
days_since_last_used IN NUMBER);
TBD
 
RECORD_XML_TAG_AND_VALUE (new 23ai)
Undocumented dbms_swat_xml.record_xml_tag_and_value(
tag   IN VARCHAR2,
value IN VARCHAR2);
TBD
 
SET_SWAT_MM_START_TIME (new 23ai)
Undocumented dbms_swat_xml.set_swat_mm_start_time(in_swat_mm_start_time IN DATE);
exec dbms_swat_xml.set_swat_mm_start_time(SYSDATE);
     *
PLS-00904: insufficient privilege to access object DBMS_SWAT_XML

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SWAT
DBMS_SWAT_ARM_INTERNAL
DBMS_SWAT_INTERNAL
DBMS_SWAT_MM_INTERNAL
DBMS_SWAT_MM_UTILS
DBMS_SWAT_VER_INTERNAL
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved