Purpose
Shows all information for Health Monitor runs.
Syntax and Description
show hm_run [-p "predicate_string"]
predicate_string is a SQL-like predicate specifying the field names to select. Table 17-14 displays the list of field names you can use.
Table 17-14 Fields for Health Monitor Runs
| Field | Type |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Examples
This example displays data for all Health Monitor runs:
show hm_run
This example displays data for the Health Monitor run with ID 123:
show hm_run -p "run_id=123"
Oracle Database Administrator's Guide for more information about Health Monitor