CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_HM
Version 11.1
 
General Information
Note: Health checks operate on the following catalog tables access$, bootstrap$, ccol$, cdef$, clu$, col$, coltype$, con$, defrole$, dependency$, dual$, ecol$, fet$, file$, icol$, icoldep$, ind$, lob$, ntab$, obj$, objauth$, objpriv$, opqtype$, refcon$, seg$, seq$,  subcoltype$, superobj$, syn$, sysauth$, tab$, ts$, tsq$, typed_view$, uet$, ugroup$, undo$, user$, view$, viewcon$
Source {ORACLE_HOME}/rdbms/admin/dbmshm.sql
First Available 11.1
Dependent Objects
gv$hm_check gv$hm_info
gv$hm_check_param gv$hm_recommendation
gv$hm_finding gv$hm_run
Exceptions
Number Name
-111 internal_error
Operating System Directory %ORACLE_BASE/diag/rdbms/orabase/orabase/hm
Security Model Execute is granted to the DBA role
 
CREATE_OFFLINE_DICTIONARY
Creates LogMiner offline dictionary in ADR dbms_hm.create_offline_dictionary;
exec dbms_hm.create_offline_dictionary;
 
CREATE_SCHEMA
Creates HM Schema in ADR dbms_hm.create_schema;
exec dbms_hm.create_schema;
 
DROP_SCHEMA
Drops HM Schema in ADR dbms_hm.drop_schema(force IN BOOLEAN);
exec dbms_hm.drop_schema(FALSE);
 
GET_RUN_REPORT

Returns the report for the specified checker run
dbms_hm.get_run_report(
run_name IN VARCHAR2,
type     IN VARCHAR2 := 'TEXT',  -- 'XML', 'TEXT', 'HTML'
level    IN VARCHAR2 := 'BASIC') -- 'BASIC', 'DETAIL'
RETURN CLOB;
desc gv$hm_run

SELECT name FROM gv$hm_run;

set long 1000000

spool c: emp\uwhm.xml

SELECT dbms_hm.get_run_report('HM_RUN_1', 'XML', 'DETAIL') FROM dual;

spool off
 
RUN_CHECK

Runs the specified checker with the given arguments. The run's report will be maintained persistently in database.
dbms_hm.run_check(check_name IN VARCHAR2,
checkname    IN VARCHAR2,
run_name     IN VARCHAR2 := NULL,
timeout      IN NUMBER   := NULL,
input_params IN VARCHAR2 := NULL);

Checkers

DB Structure Integrity Check
Data Block Integrity Check
Dictionary Integrity Check
Redo Integrity Check
Transaction Integrity Check
Undo Segment Integrity Check

Check names and their parameters can be accessed from the gv$hm_check and gv$gm_check_param.
Users can run all checks which are not internal in nature for example:

SELECT name
FROM gv$hm_check
WHERE internal_check = 'N';


which retrieves the list of checks that can be run manually by users.

SELECT name FROM gv$hm_check;

SELECT name FROM gv$hm_check
WHERE internal_check = 'N';

SELECT run_id FROM gv$hm_run;

exec dbms_hm.run_check('Dictionary Integrity Check', 'Run 2', 60);

SELECT run_id, name, check_name, run_mode, status, src_incident, num_incident, error_number
FROM gv$hm_run;

set linesize 121
col description format a40
col damage_description format a40

SELECT finding_id, status, type, description, damage_description
FROM gv$hm_finding
WHERE run_id = 221;

col name format a10
col repair_script format a60

SELECT name, type, rank, status, repair_script
FROM
gv_$hm_recommendation
WHERE run_id = 21
AND fdg_id = 22;
 
RUN_DDE_ACTION

Runs a DDE (user) action for HM checks ... Appears to be for internal usage only
dbms_hm.run_dde_action(
incident_id    IN NUMBER,
directory_name IN VARCHAR2,
check_name     IN VARCHAR2,
run_name       IN VARCHAR2,
timeout        IN NUMBER,
params         IN VARCHAR2)
RETURN BOOLEAN;
SELECT num_incident, check_name, name, timeout
FROM gv$hm_run;
 
Queries

DBMS_HM Related Queries
set linesize 131
col check_name format a30
col parameter_name format a15
col type format a15
col default_value format a15
col description format a40

SELECT c.name check_name, p.name parameter_name, p.type,
p.default_value, 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;
 
Related Topics
ADRCI
DBMS_IR
DBMS_SQLDIAG
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [196 users online]    © 2010 psoug.org