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
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(64) Description of what the check does