Oracle教程

Oracle 视图 DBA_AUTO_MV_ANALYSIS_ACTIONS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_AUTO_MV_ANALYSIS_ACTIONS的用途是显示执行的基于MV的自动分析操作及其历史信息。

此视图包含每次从发布之后执行的自动MV分析操作的详细信息，如果支持，还包括其他自动维护任务的统计信息。

可以使用此视图来监测由自动基于MV的分析执行的任务，以及这些任务的执行时间和结果，以及在重新分析时发生的变化情况。

对于查询视图，可以使用多个条件来提取详细信息，例如：执行时间、成功执行的情况、历史变更情况、失败的情况等。

还可以使用DBMS_AUTO_MV_ANALYZE.CLEAR_ANALYZE_HISTORY存储过程来删除特定类型的历史信息。

官方英文解释

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.


数据运维技术 » Oracle 视图 DBA_AUTO_MV_ANALYSIS_ACTIONS 官方解释，作用，如何使用详细说明
分享到：

相关推荐