Details: Automatic Zone Maps - Package

This page provides more detailed information about the new package related to automatic zone maps.

The new DBMS_AUTO_ZONEMAP.CONFIGURE package and procedure allow you to set configuration options for automatic zone maps, specifically to enable or disable the feature and to control foreground or background mode of the feature. There are four values allowed for the second parameter:

  • ON: Turns on automatic zone map completely, both for foreground and background zone maps creation and maintenance
  • OFF: Turns off automatic zone map completely, both for foreground and background zone maps creation and maintenance
  • FOREGROUND: Turns on only for foreground zone maps creation and maintenance
  • BACKGROUND: Turns on only for background zone maps creation and maintenance

The DBMS_AUTO_ZONEMAP.ACTIVITY_REPORT procedure reports automatic zone maps activity for a given time window. Because the zone maps autotask background job is scheduled for every 15 minutes and runs for one hour or less, users can query the actions performed by the zone map autotask for a given time window. The function uses four parameters:

  • START_TIME: Timestamp from which auto zone map executions are observed for the report. NULL value reports everything from the beginning of auto zone maps maintenance. Default value is NULL.
  • END_TIME: Timestamp until which auto zone map executions are observed for the report. NULL value reports everything to the end of auto zone maps maintenance. Default value is NULL.

    Note:

    If NULL is specified for both START_TIME and END_TIME, DBMS_AUTO_ZONEMAP.ACTIVITY_REPORT reports activity of the last execution.
  • TYPE: Output type of the report. Possible values are: TEXT, XML and HTML. Default value is TEXT.
  • SECTION: Particular section in the report. Possible values are SUMMARY, DETAILS and ALL. Default value is ALL.
    • SUMMARY: Very high level summary on new zone maps created and maintained for the given time window
    • DETAILS: Detailed summary report on names and other details of new zone maps created and maintained for the given time window. It also includes findings details.
    • ALL: In addition to summary and details, it includes time series based execution / action logs.
  • LEVEL: Format of the report. It represents the level of details within each section. Possible values are BASIC, TYPICAL and ALL. Default is TYPICAL.
    • BASIC: Presents very high level details in an executive summary. Users only see numbers on zone maps that were created, complete rebuilt and fast rebuilt. In the new zone map details section, you can see the new zone map name, date created and base table name. Maintenance details section shows only zone map name, previous state and current state. Similarly, findings section shows only object name and blacklist reason, and no other details. Action logs section shows only important time series based log messages pertaining to zone maps creation and maintenance.
    • TYPICAL: Everything in basic level and more comprehensive than basic. This level shows full overview in the executive summary section. New zone maps details shows schema name, column list and date created. Zone maps maintenance details section shows refresh type, date maintained. Findings section shows timestamp and exception message. Action logs section shows more comprehensive logs than basic, which has information about candidate column list, findings information and creation DDLs.
    • ALL: On top of typical level are shown DOP used for each operation for creating or maintaining zone maps, time took to process each DDL and other details in action logs. Shows all log messages with details on clustering ratios of columns, exception messages and other details.