5.179 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.