Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 606

Although most of the checks can be executed without using any parameters, others require parameters. In the
preceding execution, 'MV_DFRUN1' is the name of the run. The V$HM_CHECK_PARM script gives a list of checks and the
required parameters to complete the operation.
V$HM_CHECK_PARM
To access the list of checks and requirements, use the following query:
Script Name: MVRACTnTop_hmparmlist.sql 1
SELECT c.NAME CHECK_NAME ,
p.NAME PARAMETER_NAME,
p.DESCRIPTION
FROM V$HM_CHECK_PARAM p,
V$HM_CHECK c
WHERE p.CHECK_ID = c.ID
AND c.INTERNAL_CHECK = 'N'
ORDER BY c.NAME;
CHECK_NAME PARAMETER_NAME DESCRIPTION
---------------------------- ------------------ --------------------
ASM Allocation Check ASM_DISK_GRP_NAME ASM group name
CF Block Integrity Check CF_BL_NUM Control file block number
Data Block Integrity Check BLC_DF_NUM File number
Data Block Integrity Check BLC_BL_NUM Block number
Dictionary Integrity Check CHECK_MASK Check mask
Dictionary Integrity Check TABLE_NAME Table name
Redo Integrity Check SCN_TEXT SCN of the latest good redo (if known)
Transaction Integrity Check TXN_ID Transaction ID
Undo Segment Integrity Check USN_NUMBER Undo segment number
V$HM_RUN
The status of the execution can be viewed from V$HM_RUN view:
Script Name: MVRACPDnTap_HMRunStatus.sql
SELECT INST_ID INT ,
NAME ,
CHECK_NAME ,
RUN_MODE ,
STATUS ,
SRC_INCIDENT SI,
NUM_INCIDENT NI,
ERROR_NUMBER EN
FROM GV$HM_RUN
WHERE RUN_MODE <> 'REACTIVE'
ORDER BY INST_ID;
1 Source: Oracle Corporation.