Oracle | DBMS_AUTO

Oracle DBMS_AUTO_ZONEMAP Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Provides autonomous maintenance and creation of zone maps.

AUTHID DEFINER

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-TBD

First Available 20c

Security Model Owned by SYS with EXECUTE granted to TBD

Source {ORACLE_HOME}/rdbms/admin/prvtsazm.plb

Subprograms

ACTIVITY_REPORT

CONFIGURE

GET_AUTO_ZONEMAP_MODE

ACTIVITY_REPORT (new 20c)

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 NULL, -- valid values HTML, TEXT, XML section IN VARCHAR2 DEFAULT NULL, -- valid values ALL, DETAIL, SUMMARY level IN VARCHAR2 DEFAULT NULL) -- valid values ALL, BASIC, TYPICAL RETURNS CLOB;

SELECT dbms_auto_zonemap.activity_report

      FROM dual;

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;

Returns a typical level execution history from beginning to end_time

SELECT dbms_auto_zonemap.activity_report(NULL, SYSTIMESTAMP-1)

      FROM dual;

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

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

      FROM dual;

Returns typical details report from start to end time

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

      FROM dual;

CONFIGURE (new 20c)

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

GET_AUTO_ZONEMAP_MODE (new 21c)

Undocumented

This new function is likely calling DBMS_AUTO_ZONEMAP_INTERNAL GET_AUTOZM_MODE which is similarly broken with an identical error message dbms_auto_zonemap.get_auto_zonemap_mode RETURN VARCHAR2;

SELECT dbms_auto_zonemap.get_auto_zonemap_mode

      FROM dual;

      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