V$HM_INFO

V$HM_INFO displays information about Health Monitor runs, findings, and recommendations. The information for a run/finding/recommendation is organized as a name, value pair.

If the type of information is RUN, then the data represents the input parameters for that run. If the type of information is FINDING or RECOMMENDATION, then the data represents the information about that particular finding/recommendation.

Column	Datatype	Description
`ID`	`NUMBER`	Unique identifier of the information
`TYPE`	`VARCHAR2(14)`	Type of the information: `RUN` `RUN-RESUME` `FINDING` `RECOMMENDATION`
`NAME`	`VARCHAR2(32)`	Information parameter name
`VALUE`	`VARCHAR2(513)`	Information parameter value

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database Reference 11g Release 2 (11.2)
Initialization Parameters
Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to XS_SESSION_ROLES
Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
Dynamic Performance (V$) Views: V$INDEXED_FIXED_COLUMN to V$RULE_SET_AGGREGATE_STATS
Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$XSTREAM_TRANSACTION
Database Limits
SQL Scripts
Oracle Wait Events
Oracle Enqueue Names
Statistics Descriptions
Background Processes

New and changed documents:

HTML

PDF