Oracle | DBMS_AUTO_ZONEMAP

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

      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.