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 is now availble. If you haven't you downloaded already: Why?

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.