This page provides more detailed information about the new package related to automatic zone maps.
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
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
DBMS_AUTO_ZONEMAP.ACTIVITY_REPORTreports activity of the last execution.
TYPE: Output type of the report. Possible values are:
HTML. Default value is
SECTION: Particular section in the report. Possible values are
ALL. Default value is
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
ALL. Default is
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.