59 DBMS_HM

This package contains constants and procedure declarations for health check management. Health Monitor provides facilities to run a check store and retrieve the reports through DBMS_HM package

Using DBMS_HM

Security Model

Security Model

Users must have EXECUTE privilege to run the procedures of DBMS_HM package.

Summary of DBMS_HM Subprograms

Table 59-1 DBMS_HM Package Subprograms

Subprogram	Description
GET_RUN_REPORT Function	Returns the report for the specified checker run
RUN_CHECK Procedure	Runs the specified checker with the given arguments

GET_RUN_REPORT Function

This function returns the report for the specified checker run.

Syntax

DBMS_HM.GET_RUN_REPORT (
    run_name      IN  VARCHAR2,
    type           IN  VARCHAR2 := 'TEXT',
    level          IN  VARCHAR2 := 'BASIC',) 
  RETURN CLOB;

Parameters

Table 59-2 GET_RUN_REPORT Function Parameters

Parameter	Description
`run_name`	Name of the check's run
`type`	Report format type. Possible values are `'HTML'`, `'XML'` and `'TEXT'`. Default report type is `'TEXT'`.
`level`	Details of report, possible value are `'BASIC'` and `'DETAIL'`. Caution: Currently only `'BASIC'` level is supported.

RUN_CHECK Procedure

This procedure runs the specified checker with the given arguments. It lets user to specify a name for the run, inputs needed and maximum timeout for the run. The run's report will be maintained persistently in database.

Syntax

DBMS_HM.RUN_CHECK (
   check_name     IN  VARCHAR2,
   run_name       IN  VARCHAR2 := NULL,
   timeout        IN  NUMBER := NULL,
   input_params   IN  VARCHAR2 := NULL);

Parameters

Table 59-3 RUN_CHECK Procedure Parameters

Parameter	Description
`check_name`	Name of the check to be invoked. Check names and their parameters can be accessed from the `V$HM_CHECK` and `V$HM_CHECK_PARAM` views. Users can run all checks which are not internal in nature: `SELECT` name `FROM` `V$HM_CHECK` `WHERE` `INTERNAL_CHECK` `=` `'N'` retrieves the list of checks that can be run manually by users.
`run_name`	Name with which external users can uniquely identify this check's run. If `NULL` value is passed, then HM creates a unique name and associates with this check's run.
`timeout`	Maximum amount of time (in units of seconds), this checker run is allowed to run. HM will interrupt the run, if it the specified time elapses for the run. If `NULL` value is passed, HM doesn't impose any timeout limits on the run.
`input_params`	Input string: which consists of name, value pairs de-limited by a special character ';'. Example ('Data Block Integrity Check' invocation may take following type of input parameters. 'BLC_DF_NUM=1;BLC_BL_NUM=23456' Input parameters `BLC_DF_NUM` and `BLC_BL_NUM` have values '1' and '23456' respectively. Every check will have well defined set of inputs associated with it. These Input parameters, their types, default values and descriptions can be obtained using `V$HM_CHECK_PARAM` view. Example: The following query gets the list of parameters, their default values and descriptions for a 'Data Block Integrity Check' SELECT a.* FROM v$hm_check_param a, v$hm_check b WHERE a.check_id = b.id AND b.name = 'Data Block Integrity Check';