Oracle | DBMS_MDX

Oracle DBMS_MDX_UTIL Version 21c

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.

Purpose Multi-Dimensional SQL utilities for MDX support.

AUTHID CURRENT_USER

Dependencies

DBMS_HCS_LIB

Documented No

First Available 20c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsodbo.sql

FLUSH_CURSORS (new 21c)

Flushes MDX ODBO cursors from memory dbms_mdx_util.flush_cursors; PRAGMA supplemental_log_data(flush_cursors, READ_ONLY);

exec dbms_mdx_util.flush_cursors;