Oracle | DBMS_AUTO_ZONEMAP

Oracle DBMS_AUTO_ZONEMAP_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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	TS$
DBA_TABLES	DBMS_STANDARD	USER$
DBA_ZONEMAPS	DBMS_SYSTEM	V$PQ_SESSTAT
DBA_ZONEMAP_AUTO_ACTIONS	DBMS_SYS_ERROR	V$ZONEMAP_USAGE_STATS
DBA_ZONEMAP_AUTO_FINDINGS	DBMS_ZMAP_LIB	WRI$_ADV_FINDINGS
DBMS_ADVISOR	DUAL	WRI$_ADV_TASKS
DBMS_ASSERT	OBJ$	WRI$_ADV_ZONEMAP
DBMS_AUTO_CLUSTERING_INTERNAL	PRVT_ADVISOR	X$KSPPCV
DBMS_AUTO_TASK_ADMIN	SMB$CONFIG	X$KSPPI
DBMS_AUTO_ZONEMAP	TAB$	XMLTYPE
DBMS_SMB_INTERNAL

Documented No

First Available 20c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsazm.plb

Subprograms

CONFIGURE	ZMAP_CLEAR_AUTO_UGA	ZMAP_INIT_AUTO_UGA
ZMAP_AUTOTSK_DISABLE	ZMAP_EXECUTE	ZMAP_INSERT_DEFAULT_PARAMETER
ZMAP_AUTOTSK_ENABLE	ZMAP_GET_AUTOZM_MODE	ZMAP_REPORT
ZMAP_CANDIDATE_TABLE_MIN_SIZE	ZMAP_INIT	ZONEMAP_AUTO_PROCESS
ZMAP_CLEANUP

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;

      

      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 returns the same exception in 23.8 dbms_auto_zonemap_internal.zmap_execute;

exec dbms_auto_zonemap_internal.zmap_execute;

      *

      ORA-40216: feature not supported

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 23.8 dbms_auto_zonemap_internal.zmap_get_autozm_mode RETURN VARCHAR2;

SELECT dbms_auto_zonemap_internal.zmap_get_autozm_mode;

      *

      ORA-40216: feature not supported

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.