Oracle DBMS_XMLINDEX0
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Supporting package for DBMS_XMLINDEX
AUTHID CURRENT_USER
Dependencies
DBA_XML_INDEXES DBMS_XMLINDEX XMLINDEX_LIB
Documented No
First Available Not Known
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtxidx.plb
Subprograms
 
CREATEDATEINDEX
Appears to be the support for the corresponding DBMS_XMLINDEX procedure dbms_xmlindex0.createDateIndex(
xml_index_schema  IN VARCHAR2,
xml_index_name    IN VARCHAR2,
date_index_name   IN VARCHAR2,
xmltypename       IN VARCHAR2,
date_index_clause IN VARCHAR2,
column_name       IN VARCHAR2);
TBD
 
CREATENUMBERINDEX
Appears to be the support for the corresponding DBMS_XMLINDEX procedure dbms_xmlindex0.createNumberIndex(
xml_index_schema IN VARCHAR2,
xml_index_name   IN VARCHAR2,
num_index_name   IN VARCHAR2,
num_index_clause IN VARCHAR2,
xmltypename      IN VARCHAR2,
column_name      IN VARCHAR2);
TBD
 
GETPARAMETERNAME
Undocumented dbms_xmlindex0.getParameterName(paramstr IN VARCHAR2) RETURN VARCHAR2;
SELECT xdb.dbms_xmlindex0.getParameterName('Test')
FROM dual;
 
RELOAD_SXI_LEAF
Undocumented dbms_xmlindex0.reload_sxi_leaf(
xml_index_schema IN VARCHAR2,
xml_index_name   IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_XMLINDEX
What's New In 18cR3
What's New In 19cR2

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