5.175 DBA_AUTO_MV_ANALYSIS_EXECUTIONS

DBA_AUTO_MV_ANALYSIS_EXECUTIONS displays information about analysis and tuning executions associated with automatic materialized views.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the task

TASK_ID

NUMBER

NOT NULL

Unique 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)

NOT NULL

Name of the task execution with which this entry (row) is associated

EXECUTION_ID

NUMBER

NOT NULL

Execution ID

DESCRIPTION

VARCHAR2(256)

User-supplied description of the task

EXECUTION_TYPE

VARCHAR2(128)

Type of the last execution (optional for single-execution tasks)

EXECUTION_TYPE#

NUMBER

Reserved for internal use

EXECUTION_START

DATE

Execution start date and time

EXECUTION_LAST_MODIFIED

DATE

NOT NULL

Last modified date and time for the execution

EXECUTION_END

DATE

Execution end date and time

REQUESTED_DOP

NUMBER

The degree of parallelism (DOP) value requested by the user (through the TEST_EXECUTE_DOP parameter). It can be any value greater or equal to zero.

ACTUAL_DOP

NUMBER

The actual degree of parallelism (DOP) with which the execution finished. If the requested DOP is greater than than what is available on the system, the ACTUAL_DOP value can be lower than the REQUESTED_DOP value.

CONCURRENT_EXECUTION

VARCHAR2(3)

Indicates whether concurrency was used for this execution (YES) or not (NO)

ADVISOR_NAME

VARCHAR2(128)

Advisor associated with the task

ADVISOR_ID

NUMBER

NOT NULL

Unique identifier for the advisor

STATUS

VARCHAR2(11)

Current operational status of the task:

  • EXECUTING

  • COMPLETED

  • INTERRUPTED

  • CANCELLED

  • FATAL ERROR

STATUS#

NUMBER

NOT NULL

Reserved for internal use

STATUS_MESSAGE

VARCHAR2(4000)

Informational message provided by the advisor regarding the status

ERROR_MESSAGE

VARCHAR2(4000)

Informational message or an error message indicating the current operation or condition

Note:

This view is available starting with Oracle Database 21c.