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 will be available on generic Linux platforms in January and soon on AIX and Windows

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