fOracle DBMS_AUTO_ZONEMAP_INTERNAL
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 Internal utilities providing support for autonomous maintenance and creation of zone maps.
AUTHID DEFINER
Data Types sys.dbms_auto_zonemap_internal.zmap_ctx_type ...

sys.dbms_auto_zonemap_internal.zmap_finding_ctx_type ...
Dependencies
COL$ DBMS_STANDARD USER$
DBA_TABLES DBMS_SYSTEM V$PQ_SESSTAT
DBA_ZONEMAPS DBMS_SYS_ERROR V$ZONEMAP_USAGE_STATS
DBA_ZONEMAP_AUTO_ACTIONS DBMS_ZMAP_LIB WRI$_ADV_FINDINGS
DBA_ZONEMAP_AUTO_FINDINGS DUAL WRI$_ADV_TASKS
DBMS_ADVISOR OBJ$ WRI$_ADV_ZONEMAP
DBMS_ASSERT PRVT_ADVISOR X$KSPPCV
DBMS_AUTO_TASK_ADMIN TAB$ X$KSPPI
DBMS_AUTO_ZONEMAP TS$ XMLTYPE
Documented No
First Available 20c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsazm.plb
Subprograms
 
CONFIGURE (new 20c)
Undocumented dbms_auto_zonemap_internal.configure(
parameter_name  IN VARCHAR2,
parameter_value IN VARCHAR2)
TBD
 
ZMAP_AUTOTSK_DISABLE (new 20c)
Disable Zonemap Auto Task jobs dbms_auto_zonemap_internal.zmap_autotsk_disable;
exec dbms_auto_zonemap_internal.zmap_autotsk_disable;

PL/SQL procedure successfully completed.
 
ZMAP_AUTOTSK_ENABLE (new 20c)
Enable Zonemap Auto Task jobs dbms_auto_zonemap_internal.zmap_autotsk_enable;
exec dbms_auto_zonemap_internal.zmap_autotsk_enable;

PL/SQL procedure successfully completed.
 
ZMAP_CANDIDATE_TABLE_MIN_SIZE (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_candidate_table_min_size RETURN NUMBER;
SELECT dbms_auto_zonemap_internal.zmap_candidate_table_min_size
FROM dual;

ZMAP_CANDIDATE_TABLE_MIN_SIZE
-----------------------------
                         5000
 
ZMAP_CLEANUP (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_cleanup;
exec dbms_auto_zonemap_internal.zmap_cleanup;

PL/SQL procedure successfully completed.
 
ZMAP_CLEAR_AUTO_UGA (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_clear_auto_uga;
exec dbms_auto_zonemap_internal.zmap_clear_auto_uga;

PL/SQL procedure successfully completed.
 
ZMAP_EXECUTE (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_execute;
exec dbms_auto_zonemap_internal.zmap_execute;
BEGIN dbms_auto_zonemap_internal.zmap_execute; END;
*
ERROR at line 1:
ORA-40216: feature not supported
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 66
ORA-06512: at "SYS.DBMS_AUTO_ZONEMAP_INTERNAL", line 233
ORA-06512: at line 1
 
ZMAP_GET_AUTOZM_MODE (new 21)
Presumably returns the current auto zonemap mode

This function was not present in 20c and appears to not be ready for use in 21c.
dbms_auto_zonemap_internal.zmap_get_autozm_mode RETURN VARCHAR2;
DECLARE
 retVal dbms_id;
BEGIN
  retVal :=  dbms_auto_zonemap_internal.zmap_get_autozm_mode;
  dbms_output.put_line(retVal);
END;
/
DECLARE
*
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 line 4
 
ZMAP_INIT (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_init;
exec dbms_auto_zonemap_internal.zmap_init;

PL/SQL procedure successfully completed.
 
ZMAP_INIT_AUTO_UGA (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_init_auto_uga;
exec dbms_auto_zonemap_internal.zmap_init_auto_uga;

PL/SQL procedure successfully completed.
 
ZMAP_INSERT_DEFAULT_PARAMETER (new 21c)
Undocumented dbms_auto_zonemap_internal.zmap_init_parallelism;
exec dbms_auto_zonemap_internal.zmap_init_parallelism;

PL/SQL procedure successfully completed.
 
ZMAP_REPORT (new 20c)
Undocumented dbms_auto_zonemap_internal.zmap_report(
start_time IN     TIMESTAMP WITH TIME ZONE,
end_time   IN     TIMESTAMP WITH TIME ZONE,
report_xml IN OUT sys.xmltype,
section    IN     VARCHAR2,
level      IN     VARCHAR2);
TBD
 
ZONEMAP_AUTO_PROCESS (new 20c)
Undocumented dbms_auto_zonemap_internal.zonemap_auto_process(zonemap_task_id IN NUMBER);
exec dbms_auto_zonemap_internal.zonemap_auto_process(3);

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AUTO_ZONEMAP
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