DBA_AUTO_MV_ANALYSIS

5.131 DBA_AUTO_MV_ANALYSIS_ACTIONS

DBA_AUTO_MV_ANALYSIS_ACTIONS displays information about analysis and tuning activities associated with automatic materialized views.

Each action is specified by the COMMAND and attribute (ATTR1 through ATTR6) columns. Each command defines how the attribute columns will be used.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Identifier of the task
`TASK_NAME`	`VARCHAR2(128)`		Name of the task The value of this column is always `SYS_AUTO_MV_TASK`.
`EXECUTION_NAME`	`VARCHAR2(128)`		The name of the task execution with which this entry (row) is associated
`REC_ID`	`NUMBER`	`NOT NULL`	Recommendation associated with the action
`ACTION_ID`	`NUMBER`	`NOT NULL`	Unique identifier for the action
`OBJECT_ID`	`NUMBER`		Object associated with the action
`COMMAND`	`VARCHAR2(64)`		Command to be executed See Also: `DBA_ADVISOR_COMMANDS` for a list of commands
`COMMAND_ID`	`NUMBER`	`NOT NULL`	ID of the command to be executed See Also: `DBA_ADVISOR_COMMANDS` for a list of commands
`FLAGS`	`NUMBER`		Advisor-specific flags
`ATTR1`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR2`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR3`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR4`	`VARCHAR2(4000)`		Parameters defining the command
`ATTR5`	`CLOB`		Parameters defining the command; to be used if the text is significantly large (for example, a SQL statement defining a materialized view)
`ATTR6`	`CLOB`		Parameters defining the command; to be used if the text is significantly large (for example, a SQL statement defining a materialized view)
`NUM_ATTR1`	`NUMBER`		General numeric attribute
`NUM_ATTR2`	`NUMBER`		General numeric attribute
`NUM_ATTR3`	`NUMBER`		General numeric attribute
`NUM_ATTR4`	`NUMBER`		General numeric attribute
`NUM_ATTR5`	`NUMBER`		General numeric attribute
`MESSAGE`	`VARCHAR2(4000)`		Message associated with the action
`FILTERED`	`VARCHAR2(1)`		A value of `Y` means that the row in the view was filtered out by a directive (or a combination of directives). A value of `N` means that the row was not filtered.
`RESULT_STATUS`	`VARCHAR2(25)`		Result status. Possible values: `AUTOMATION PENDING` `TIMED OUT` `MISSING INFORMATION` `COMPLETED WITH NO RESULTS` `COMPLETED AND IMPLEMENTED` `ENCOUNTERED ERROR` `NOT AUTOMATED`
`RESULT_LAST_MODIFIED`	`TIMESTAMP(3)`		Time at which result status was last modified
`RESULT_MESSAGE`	`VARCHAR2(4000)`		Result message text

Note:

This view is available starting with Oracle Database 21c.