Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$HM_RUN

V$HM_RUN displays information about all Health Monitor checks and their status.

Column Datatype Description
RUN_ID NUMBER Unique ID to represent the run
NAME VARCHAR2(32) Unique name used to identify the run
CHECK_NAME VARCHAR2(32) Name of the check
RUN_MODE VARCHAR2(8) Mode of the run:
  • MANUAL

  • REACTIVE

  • AUTO

TIMEOUT NUMBER Number of seconds allowed for this run to complete before it is aborted
START_TIME TIMESTAMP(6) Start time of the run
LAST_RESUME_TIME TIMESTAMP(6) Last resumed time for the run
END_TIME TIMESTAMP(6) End time of the run
MODIFIED_TIME TIMESTAMP(6) Last modified time of the run record
STATUS VARCHAR2(11) Status of the run:
  • INITIAL

  • EXECUTING

  • INTERRUPTED

  • TIMEDOUT

  • CANCELLED

  • COMPLETED

  • ERROR

SRC_INCIDENT NUMBER Source incident ID that activated this run
NUM_INCIDENT NUMBER Number of incidents created by this run
ERROR_NUMBER NUMBER Error number if the run failed to complete because of an error
PROBLEM_ID NUMBER Problem ID of the source incident ID that may have activated this Run