This chapter provides a description of each metric view and its columns. It contains the following sections:
For examples of how to use views, see Examples.
The MGMT$METRIC_CATEGORIES view displays the list of classes and categories to which the metric belongs. It can be used to classify the metric based on the class (such as service or functional) and category within the class (such as security or configuration under functional class or usage or performance under service class).
Table 12-1 MGMT$METRIC_CATEGORIES
Column | Description |
---|---|
TARGET_TYPE |
Defines the target type of the metric being categorized |
TYPE_VERSION |
Defines the version of the target type |
METRIC_NAME |
Defines the name of the metric |
METRIC_COLUMN |
For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, then the value in this column is a single space. |
METRIC_GUID |
A unique ID for the metric |
METRIC_CLASS_NAME |
Name of the metric class to which this metric belongs |
METRIC_CATEGORY_NAME |
Name of the category of the metric in the class |
METRIC_CATEGORY_NLSID |
The NLS ID of the category which is used by Enterprise Manager to translate the name to different languages |
The MGMT$METRIC_COLLECTION view provides the metric thresholds details, frequency, upload policy, and thresholds per target.
Table 12-2 MGMT$METRIC_COLLECTION
Column | Description |
---|---|
TARGET_NAME |
Target where the metrics will be collected |
TARGET_TYPE |
Defines the set of metrics that are applicable for the target |
TARGET_GUID |
The unique id of the target |
METRIC_NAME |
Name of the metric |
METRIC_COLUMN |
For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, then the value in this column is a single space. |
WARNING_OPERATOR |
The operator for the warning threshold. This is used in the reporting environment to create a line on the graph representing the warning threshold appropriately. Possible values:
|
CRITICAL_OPERATOR |
The operator for the critical threshold. This is used in the reporting environment to create a line on the graph representing the critical threshold appropriately. Possible values:
|
WARNING_THRESHOLD |
Value for the warning severity |
CRITICAL_THRESHOLD |
Value for the critical severity |
OCCURENCE_COUNT |
The number of occurrences of a warning, critical, or clear severity before a severity record is generated |
WARNING_COUNT |
The number of consecutive times a metric value has exceeded the warning threshold |
CRITICAL_COUNT |
The number of consecutive times a metric value has exceeded the critical threshold |
The MGMT$METRIC_ERROR_CURRENT view associates current metric errors pertaining to a metric.
Table 12-3 MGMT$METRIC_ERROR_CURRENT
Column | Description |
---|---|
TARGET_NAME |
Name of the target for which the metric collection error occurred |
TARGET_TYPE |
Target type defines the set of metrics that are applicable for the target |
TARGET_GUID |
The unique ID of the target for which the metric collection error occurred |
METRIC_NAME |
The underlying metric for which the metric collection error occurred |
METRIC_GUID |
A unique ID for the metric. It can be used to associate metric information with metric data information during reporting |
METRIC_LABEL |
User display name of the metric for which the error occurred |
COLL_NAME |
Name of the collection collecting the metric for which the error occurred |
COLLECTION_TIMESTAMP |
Time when the collection error occurred |
ERROR_TYPE |
Indicates the type of error that happened during the collection of the metric Possible values:
|
ERROR_MESSAGE |
Text of the error message |
The MGMT$METRIC_ERROR_HISTORY view displays the history of metric collection errors.
Table 12-4 METRIC_ERROR_HISTORY
Column | Description |
---|---|
TARGET_NAME |
The name of the target for which the metric collection error occurred |
TARGET_TYPE |
Target type defines the set of metrics that are applicable for the target |
TARGET_GUID |
Target GUID of the target for which the metric collection error occurred |
METRIC_NAME |
Name of the metric for which the error occurred |
METRIC_GUID |
A unique ID for the metric. It can be used to associate metric information with metric data information during reporting |
METRIC_LABEL |
User display name of the metric for which the error occurred |
COLL_NAME |
Name of the collection collecting the metric for which the error occurred |
COLLECTION_TIMESTAMP |
The time when the collection error occurred |
ERROR_TYPE |
Indicates the type of error that happened during the collection of the metric Possible values are:
|
ERROR_MESSAGE |
Text of the error message |