Database Reference
In-Depth Information
TYPE
FROM V$HM_FINDING
ORDER BY TIME_DETECTED DESC;
Finding Run
id id NAME TIME_DETECTED PRIORITY STATUS
------- ----- ------------------- --------------- -------- --------
17801 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17798 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17795 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17792 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17789 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17786 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17783 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17780 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17777 17761 Dictionary Inconsist 09-DEC-10 02.19 CRITICAL OPEN
17 1 Datafile is old 21-AUG-10 10.11 HIGH CLOSED
8 1 Old Data Files 21-AUG-10 10.11 HIGH CLOSED
11 1 Datafile is old 21-AUG-10 10.11 HIGH CLOSED
5 1 System datafile is o 21-AUG-10 10.11 CRITICAL CLOSED
2 1 Control File needs r 21-AUG-10 10.11 CRITICAL CLOSED
The preceding output gives a list of all findings for the various incidents that have occurred in this environment.
V$HM_RECOMMENDATION
For the incidents and the reported findings, HM normally provides recommendations provided there is sufficient data
available. This view helps to display these recommendations:
SQL> DESC V$HM_RECOMMENDATION
Name Null? Type
----------------------------------------- -------- -------------------
RECOMMENDATION_ID NUMBER
FDG_ID NUMBER
RUN_ID NUMBER
NAME VARCHAR2(32)
TYPE VARCHAR2(7)
RANK NUMBER
TIME_DETECTED TIMESTAMP(6)
EXECUTED TIMESTAMP(6)
STATUS VARCHAR2(7)
DESCRIPTION VARCHAR2(1024)
REPAIR_SCRIPT VARCHAR2(512)
This view can be joined with
V$HM_FINDING
to get more detailed information.
Search WWH ::
Custom Search