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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AUTO_ZONEMAP_INTERNAL
DBMS_FEATURE_ZMAP
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx