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

In NAME CHECK_NAME RUN_MODE STATUS SrcIn #inc Err
--- --------- ---------------------------- -------- ----------- ----- ----- ----
1 MV_RUN1 Dictionary Integrity Check MANUAL COMPLETED 0 0 0
MV_RUN10 DB Structure Integrity Check MANUAL COMPLETED 0 0 0
MV_DFRUN1 Dictionary Integrity Check MANUAL COMPLETED 0 0 0
MV_RUN2 Dictionary Integrity Check MANUAL COMPLETED 0 0 0
In the preceding output, if there are checks that have incident count higher than 0, this indicates they require
further investigation. Details of the incident can be viewed using the PL/SQL procedure DBMS_HM.RUN_REPORT.
2. DBMS_HM.GET_RUN_REPORT
SQL> SET LONG 100000
SET LONGCHUNKSIZE 1000
SET PAGESIZE 1000
SET LINESIZE 512
SQL> SELECT DBMS_HM.GET_RUN_REPORT('mv_runcf3') from dual;
DBMS_HM.GET_RUN_REPORT('MV_RUNCF3')
-----------------------------------------------------------------------
Basic Run Information
Run Name : mv_runcf3
Run Id : 20301
Check Name : CF Block Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2010-12-10 21:04:21.142783 -08:00
End Time : 2010-12-10 21:04:21.264650 -08:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0
Input Paramters for the Run
CF_BL_NUM=4949
Run Findings and Recommendations
The report lists all findings and recommendations. Findings and recommendations can also be found by
querying the various Oracle provided views.
V$HM_FINDING
V$HM_FINDING displays all findings from the various checks executed from the HM. This view provides details such as
type of error, what level of criticality ( PRIORITY ), and the extent of damage ( DAMAGE_DESCRIPTION ) that has occurred
to the specific area of check performed:
Script MVRACPDnTap_HMfinding.sql
SELECT FINDING_ID FI,
RUN_ID RI ,
NAME ,
TIME_DETECTED,
PRIORITY ,
STATUS ,