Oracle DBMS_AUTO_ZONEMAP_INTERNAL
Version 23c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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_SPM_INTERNAL USER$
DBA_TABLES DBMS_STANDARD V$PQ_SESSTAT
DBA_ZONEMAPS DBMS_SYSTEM V$ZONEMAP_USAGE_STATS
DBA_ZONEMAP_AUTO_ACTIONS DBMS_SYS_ERROR WRI$_ADV_FINDINGS
DBA_ZONEMAP_AUTO_FINDINGS DBMS_ZMAP_LIB WRI$_ADV_TASKS
DBMS_ADVISOR DUAL WRI$_ADV_ZONEMAP
DBMS_ASSERT OBJ$ X$KSPPCV
DBMS_AUTO_TASK_ADMIN PRVT_ADVISOR X$KSPPI
DBMS_AUTO_ZONEMAP TAB$ XMLTYPE
DBMS_SMB_INTERNAL TS$  
Documented No
First Available 20c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsazm.plb
Subprograms
 
CONFIGURE
Undocumented dbms_auto_zonemap_internal.configure(
parameter_name  IN VARCHAR2,
parameter_value IN VARCHAR2)
TBD
 
ZMAP_AUTOTSK_DISABLE
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
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
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
Undocumented dbms_auto_zonemap_internal.zmap_cleanup;
exec dbms_auto_zonemap_internal.zmap_cleanup;

PL/SQL procedure successfully completed.
 
ZMAP_CLEAR_AUTO_UGA
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
Undocumented

This procedure was present in 20c and appears to not be ready for use in 21c and continues to fail in 23.1 Beta
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
Presumably returns the current auto zonemap mode

This function was not present in 20c and appears to not be ready for use in 21c and continues to fail in 23.1 Beta
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
Undocumented dbms_auto_zonemap_internal.zmap_init;
exec dbms_auto_zonemap_internal.zmap_init;

PL/SQL procedure successfully completed.
 
ZMAP_INIT_AUTO_UGA
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
Undocumented dbms_auto_zonemap_internal.zmap_init_parallelism;
exec dbms_auto_zonemap_internal.zmap_init_parallelism;

PL/SQL procedure successfully completed.
 
ZMAP_REPORT
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
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 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx