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