DBA_ZONEMAP_AUTO

7.170 DBA_ZONEMAP_AUTO_FINDINGS

DBA_ZONEMAP_AUTO_FINDINGS provides information about automatic zone map findings.

Column	Datatype	NULL	Description
`TASK_ID`	`NUMBER`	`NOT NULL`	Zone map task identifier
`MSG_ID`	`NUMBER`	`NOT NULL`	Zone map message identifier
`EXEC_NAME`	`VARCHAR2(128)`		Zone map execution name
`MESSAGE`	`VARCHAR2(4000)`		Execution message text
`TIME_STAMP`	`TIMESTAMP(9)`		Finding timestamp
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object for which the finding was observed, typically a table name or a zone map name
`FINDING_REASON`	`VARCHAR2(9)`		Finding reason code
`FINDING_TYPE`	`VARCHAR2(9)`		Finding type. Possible values: `BLACKLIST`: The table is no longer a candidate for automatic zone maps `ERROR`: An error occurred `EVICT`: The table does not meet automatic zone map creation criteria `OTHER` Refer to the `MESSAGE` column for additional information about the reasoning behind the finding type.

Automatic zone map findings contain information that the database learned when performing automatic zone map executions. The database uses these findings to optimize subsequent automatic zone maps executions, which saves on execution time and resources.

The TASK_ID, MSG_ID, and EXEC_NAME columns in this view correspond to the same columns in the DBA_ZONEMAP_AUTO_ACTIONS view. This allows you to correlate the findings in DBA_ZONEMAP_AUTO_FINDINGS with their corresponding actions in DBA_ZONEMAP_AUTO_ACTIONS.

Note:

This view is available starting with Oracle Database 21c.