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

V$HM_CHECK
Use the following query to view the tests and their execution types:
Script Name: MVRACTnTop_HMChecksList.sql
SQL> SELECT name,
cls_name,
internal_check,
offline_capable
FROM v$hm_check;
NAME CLS_NAME I O
---------------------------------- --------------- - -
HM Test Check GENERIC Y Y
DB Structure Integrity Check PERSISTENT_DATA N Y
CF Block Integrity Check PERSISTENT_DATA N Y
Data Block Integrity Check PERSISTENT_DATA N Y
Redo Integrity Check PERSISTENT_DATA N Y
Logical Block Check PERSISTENT_DATA Y N
Transaction Integrity Check PERSISTENT_DATA N N
Undo Segment Integrity Check PERSISTENT_DATA N N
No Mount CF Check PERSISTENT_DATA Y Y
Mount CF Check PERSISTENT_DATA Y Y
CF Member Check PERSISTENT_DATA Y Y
All Datafiles Check PERSISTENT_DATA Y Y
Single Datafile Check PERSISTENT_DATA Y Y
Tablespace Check Check PERSISTENT_DATA Y Y
Log Group Check PERSISTENT_DATA Y Y
Log Group Member Check PERSISTENT_DATA Y Y
Archived Log Check PERSISTENT_DATA Y Y
Redo Revalidation Check PERSISTENT_DATA Y Y
IO Revalidation Check PERSISTENT_DATA Y Y
Block IO Revalidation Check PERSISTENT_DATA Y Y
Failover Check PERSISTENT_DATA Y Y
Txn Revalidation Check PERSISTENT_DATA Y N
Failure Simulation Check PERSISTENT_DATA Y Y
Dictionary Integrity Check PERSISTENT_DATA N N
ASM Mount Check ASM Y Y
ASM Allocation Check ASM N Y
ASM Disk Visibility Check ASM Y Y
ASM File Busy Check ASM Y Y
ASM Toomanyoff Check ASM Y Y
ASM Insufficient Disks Check ASM Y Y
ASM Insufficient Mem Check ASM Y Y
ASM DGFDM Check No DG Name ASM Y Y
ASM DG Force Dismount Check ASM Y Y
ASM Sync IO Fail Check ASM Y Y
34 rows selected.