Oracle DBMS_AUTO_ZONEMAP
Version 20c

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.

The demos below are from the online Oracle documentation and will be replace with Library demos as soon as the general release of 20c is available.

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
AUTHID DEFINER
Constants
Name Data Type Value
General
TBD    
TBD
TBD    
Data Types TBD
Dependencies
TBD    
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/TBD
Subprograms
 
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, -- html, text, ???
section    IN VARCHAR2                 DEFAULT NULL,
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.confiure('AUTO_ZONEMAP_MODE', 'ON');

Related Topics
Built-in Functions
Built-in Packages
DBMS_FEATURE_ZMAP
What's New In 19c
What's New In 20c
Zone Maps

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