Oracle | DBMS_AUTO

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

Purpose Provides autonomous maintenance and creation of zone maps.

AUTHID CURRENT_USER

Data Types TBD

Dependencies

DBA_ZONEMAP_AUTO_ACTIONS	DBMS_REPORT	PRVT_REPORT_TAGS
DBMS_AUTO_ZONEMAP_INTERNAL	DBMS_SYS_ERROR	XMLTYPE
DBMS_OUTPUT	PRVT_ADVISOR

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-40216	feature not supported

First Available 20c

Security Model Owned by SYS with EXECUTE granted to TBD

Source {ORACLE_HOME}/rdbms/admin/dbmsazm.sql
{ORACLE_HOME}/rdbms/admin/prvtazm.plb

Subprograms

ACTIVITY_REPORT

CONFIGURE

GET_AUTO_ZONEMAP_MODE

ACTIVITY_REPORT

Reports auto zone map activity for a given time window

Returns report for all the execution history of the last execution in TEXT format and all sections are displayed with typical level dbms_auto_zonemap.activity_report( start_time IN TIMESTAMP WITH TIME ZONE DEFAULT NULL, end_time IN TIMESTAMP WITH TIME ZONE DEFAULT NULL, type IN VARCHAR2 DEFAULT 'TEXT', -- values HTML, TEXT, XML section IN VARCHAR2 DEFAULT 'DETAILS', -- values ALL, DETAIL, SUMMARY level IN VARCHAR2 DEFAULT 'TYPICAL') -- values ALL, BASIC, TYPICAL RETURNS CLOB;

SELECT dbms_auto_zonemap.activity_report;

      *

      ORA-40216: feature not supported

Returns execution history for the last two days in TEXT format at typical level

SELECT dbms_auto_zonemap.activity_report(SYSTIMESTAMP-2, NULL);

      *

      ORA-40216: feature not supported

Returns a typical level execution history from beginning to end_time

SELECT dbms_auto_zonemap.activity_report(NULL, SYSTIMESTAMP-1);

      *

      ORA-40216: feature not supported

Returns the last execution's report detail section with only basic details

SELECT dbms_auto_zonemap.activity_report(NULL, NULL, 'HTML', 'DETAILS', 'BASIC');

      *

      ORA-40216: feature not supported

Returns typical details report from start to end time

SELECT dbms_auto_zonemap.activity_report(SYSTIMESTAMP�2, SYSTIMESTAMP, 'TEXT', 'ALL', 'TYPICAL');

      *

      ORA-40216: feature not supported

CONFIGURE

Sets configuration options for auto zone map; specifically to enable or disable feature and to control foreground or background mode of the feature dbms_auto_zonemap.configure( parameter_name IN VARCHAR2, parameter_value IN VARCHAR2); -- valid values ON, OFF, FOREGROUND, BACKGROUND

exec dbms_auto_zonemap.configure('AUTO_ZONEMAP_MODE', 'ON');

      *

      ORA-40216: feature not supported

GET_AUTO_ZONEMAP_MODE

Undocumented

This function is calling DBMS_AUTO_ZONEMAP_INTERNAL GET_AUTOZM_MODE which is similarly broken with an identical error message in all versions

Note: This function returns a VARCHAR, not a VARCHAR2: A bug dbms_auto_zonemap.get_auto_zonemap_mode RETURN VARCHAR;

SELECT dbms_auto_zonemap.get_auto_zonemap_mode;

      *

      ORA-40216: feature not supported