Oracle 视图 V$HM_RECOMMENDATION 官方解释,作用,如何使用详细说明

本站中文解释

V$HM_RECOMMENDATION是Oracle Enterprise Manager Database Express中可用的一个视图,用于定期轮询V$HM_RECOMMENDATIONS检查是否有需要立即处理的推荐活动。

V$HM_RECOMMENDATION视图表中提供了关于推荐处理项概要信息,比如:推荐处理项名称、处理状态、推荐级别、创建时间和实施备注信息等。

使用方法:

1、登录Oracle Enterprise Manager Database Express。

2、点击“性能视图”,选择“V$HM_RECOMMENDATION”,查看V$HM_RECOMMENDATION视图中有哪些推荐活动。

3、点击“安全”,查看推荐的安全措施,并按要求执行必要的安全措施。

4、点击“维护”,查看推荐的维护措施,并按要求执行必要的维护措施。

5、根据不同推荐维护或安全活动,执行必要的活动。

官方英文解释

V$HM_RECOMMENDATION displays information about all the recommendations made to various Health Monitor findings.

Column Datatype Description

RECOMMENDATION_ID

NUMBER

Unique ID to represent the recommendation

FDG_ID

NUMBER

Unique ID to represent either the finding ID or the finding set ID for which the recommendation was made

RUN_ID

NUMBER

ID of the run that may have generated the recommendation

If the ID is 0, then the recommendations were generated by RMAN.

NAME

VARCHAR2(32)

Name of the recommendation

TYPE

VARCHAR2(7)

Type of the recommendation:

  • MANUAL

  • REPAIR

RANK

NUMBER

Rank of the recommendation

TIME_DETECTED

TIMESTAMP(6)

Time that the recommendation was made

EXECUTED

TIMESTAMP(6)

Time that the recommendation (repair) was implemented

STATUS

VARCHAR2(7)

Status of the recommendation (repair) execution:

  • NOT RUN

  • RUNNING

  • SUCCESS

  • FAILED

DESCRIPTION

VARCHAR2(1024)

Description of the recommendation

REPAIR_SCRIPT

VARCHAR2(512)

Location of the repair script file

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$HM_RECOMMENDATION 官方解释,作用,如何使用详细说明