V$HM_FINDING

V$HM_FINDING displays information about all the findings of various Health Monitor runs.


Column Datatype Description

FINDING_ID

NUMBER

Unique ID to represent the finding

RUN_ID

NUMBER

ID of the run that created this finding

NAME

VARCHAR2(32)

Name of the finding

PARENT_ID

NUMBER

Parent finding ID for this finding

CHILD_COUNT

NUMBER

Number of active (open) child findings, if this finding is a parent finding type

CLASS_NAME

VARCHAR2(32)

Name of the class to which this finding belongs

TIME_DETECTED

TIMESTAMP(6)

Time this finding was detected

MODIFIED

TIMESTAMP(6)

Time that this finding was last modified

PRIORITY

VARCHAR2(8)

Priority of the finding:

  • LOW,

  • HIGH

  • CRITICAL

STATUS

VARCHAR2(12)

Status of the finding:

  • OPEN

  • CLOSED

TYPE

VARCHAR2(13)

Type of the finding:

  • INFORMATIONAL

  • FAILURE

DESCRIPTION

VARCHAR2(1024)

Description of the finding

DAMAGE_DESCRIPTION

VARCHAR2(1024)

Possible damage description of the finding

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