Details: Automatic Zone Maps - Views

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

The DBA_ZONEMAP_AUTO_ACTIONS view contains five columns:

  • TASK_ID: Advisor task id for automatic zone maps
  • MSG_ID: Message ID
  • EXEC_NAME: Advisor execution name: SYS_ZMAP_<Timestamp>
  • ACTION_MSG: Execution message log
  • TIME_STAMP: Message time stamp

The DBA_ZONEMAP_AUTO_FINDINGS view contains five columns:

  • TASK_ID: Advisor task id for automatic zone maps
  • MSG_ID: Message ID
  • EXEC_NAME: Advisor execution name: SYS_ZMAP_<Timestamp>
  • MESSAGE: Execution message log
  • TIME_STAMP: Message time stamp
  • OBJECT_NAME: Object name, typically table name or zone map name on which the finding was observed
  • FINDING_REASON: Finding reason can be an error, an eviction or a time out.
  • FINDING_TYPE: Finding type can be a blacklist, back in queue and others.

The exsiting DBA_ZONEMAPS view contains three new columns:

  • AUTOMATIC: Is the zone map automatically created or not?
  • PARTLY_STALE: Is the zone map partly stale or not?
  • INCOMPLETE: Is the zone map missing zones or not?