Oracle DBMS_SWAT_XML
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?
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