Oracle | DBMS_SWAT

Oracle DBMS_SWAT_XML Version 23c

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.

SQL Workload Analysis & Tuning

Purpose TBD

AUTHID DEFINER

Dependencies

DBMS_SWAT_MM_UTILS	SWAT_MM_JOURNAL$	XMLTYPE
DBMS_XMLDOM

Documented No

First Available 23.1

Security Model Owned by SYS with no privileges granted

In 23.2 the package gained protection using the ACCESSIBLE BY clause.

Source {ORACLE_HOME}/rdbms/admin/prvsswatxml.plb
{ORACLE_HOME}/rdbms/admin/prvtswatxml.plb

Subprograms

RECORD_XML_MVLOG_DROP	RECORD_XML_MV_DROP	SET_SWAT_MM_START_TIME
RECORD_XML_MV_DDL	RECORD_XML_TAG_AND_VALUE

RECORD_XML_MVLOG_DROP (new 23c)

Undocumented dbms_swat_xml.record_xml_mvlog_drop( mvlog_owner IN VARCHAR2, mvlog_table_name IN VARCHAR2);

TBD

RECORD_XML_MV_DDL (new 23c)

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 23c)

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 23c)

Undocumented dbms_swat_xml.record_xml_tag_and_value( tag IN VARCHAR2, value IN VARCHAR2);

TBD

SET_SWAT_MM_START_TIME (new 23c)

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

           *

      ERROR at line 1:

      ORA-06550: lie 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_SWAT_XML

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored