Oracle | DBMS_AUTO_ZONEMAP

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