V$HM_CHECK

V$HM_CHECK displays information about all the checks registered with Health Monitor. Each check is uniquely identified by a name or an ID.


Column Datatype Description

ID

NUMBER

Health check ID

NAME

VARCHAR2(64)

Health check name

NAME_NLS

VARCHAR2(1024)

Internationalized names of the health checks

CLSID

NUMBER

Class ID to which this check belongs

CLS_NAME

VARCHAR2(15)

Class name of the check:

  • GENERIC

  • PERSISTENT_DATA

FLAGS

NUMBER

Reserved for internal use

INTERNAL_CHECK

VARCHAR2(1)

Internal check

OFFLINE_CAPABLE

VARCHAR2(1)

Ability to run when database is not open yet (Y or N)

DESCRIPTION

VARCHAR2(1024)

Description of what the check does

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