Oracle | DBMS_AUTO

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

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; PRAGMA SUPPLEMENTAL_LOG_DATA(activity_report, READ_ONLY);

SELECT dbms_auto_zonemap.activity_report;

      ERROR at line 1:

      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)

      FROM dual;

      ERROR at line 1:

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

      ERROR at line 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');

      ERROR at line 1:

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

      ERROR at line 1:

      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 PRAGMA SUPPLEMENTAL_LOG_DATA(configure, READ_ONLY);

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

      ERROR at line 1:

      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; PRAGMA SUPPLEMENTAL_LOG_DATA(get_auto_zonemap_mode, READ_ONLY);

SELECT dbms_auto_zonemap.get_auto_zonemap_mode;

      SELECT dbms_auto_zonemap.get_auto_zonemap_mode

      *

      ERROR at line 1:

      ORA-40216: feature not supported

      ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 295

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 148

      ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 274

      ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP", line 149