Enterprise Manager repository views are used to access information in the Management Repository for further processing and/or presentation.
Important:
Views supplied with Enterprise Manager 10g release 10.2 are provisional. Provisional views, although fully supported for the current release of Enterprise Manager 10g, may change in subsequent releases. Backward compatibility is not guaranteed for provisional views.This chapter covers the following:
The Enterprise Manager Management Repository views provide access to target, metric, and monitoring information stored in the Management Repository. Accessing the repository will allow you to perform the following:
Obtain pertinent application-specific information at the right level of granularity and density for a wider variety of users: IT staff, executives, developers.
Send alerts for metric threshold violations.
Perform historical analysis or additional computation on stored data.
Seamless integration of Enterprise Manager alerts with user ticketing systems, such as iSupport and Remedy.
The Management Repository is the comprehensive source for all the management information for Enterprise Manager, with the key to extensibility being the repository's open schema. This open architecture allows users to customize how the information in the repository is used if Enterprise Manager's standard configuration does not meet their requirements. To facilitate easy access to information stored in the repository, Enterprise Manager supplies a comprehensive set of views rather than forcing the user to access repository base tables directly. Views buffer custom applications from any underlying changes to the repository schema and ensures up-stream applications will not break when the repository schema changes via patching or new releases.
Because the views are simple queries to a database, users can imbed these queries within any application code used to return information for further processing and/or display in the Enterprise Manager Grid Control console.
As shown in Example 6-1, "View Usage", the Java code uses Enterprise Manager views to query the Management Repository rather than accessing the repository tables directly. For each of four time windows, there are four SQL statements with questions marks ('?') as placeholders for the parameters.
public static final String hour_stmt =
"SELECT collection_timestamp, value "+ "FROM mgmt$metric_details " + "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " + "and collection_timestamp > sysdate - 1/24 " + "ORDER BY collection_timestamp ";
public static final String day_stmt =
"SELECT rollup_timestamp, average "+ "FROM mgmt$metric_hourly " + "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " +
"and rollup_timestamp > sysdate - 1 " + "ORDER BY rollup_timestamp"; public static final String week_stmt =
"SELECT rollup_timestamp, average "+ "FROM mgmt$metric_daily " + "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " + "and rollup_timestamp > sysdate - 7 " + "ORDER BY rollup_timestamp";
public static final String month_stmt =
"SELECT rollup_timestamp, average "+ "FROM mgmt$metric_daily " + "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " + "and rollup_timestamp > sysdate - 31 " + "ORDER BY rollup_timestamp";
MGMT$METRIC_ERROR_HISTORY displays the history of metric collection errors that have occurred in last 3 months.
Table 6-1 MGMT$METRIC_ERROR_HISTORY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the metric collection error occurred. |
TARGET_TYPE |
VARCHAR2(64) |
Target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
Target GUID of the target for which the metric collection error occurred. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric for which the error occurred. |
METRIC_LABEL |
VARCHAR2(64) |
User display name of the metric for which the error occurred. |
COLL_NAME |
VARCHAR2(256) |
Name of the collection collecting the metric for which the error occurred. |
COLLECTION_TIMESTAMP |
DATE |
Time when the collection error occurred. |
ERROR_TYPE |
NUMBER |
Type of metric error. 0=Error 1=Warning |
ERROR_MESSAGE |
VARCHAR2(4000) |
Text of the error message. |
List the history of metric errors for a given target.
List the history of metric errors for a given target and metric.
Queries using this view would use index if target_name and target_type were specified.
MGMT$METRIC_ERROR_CURRENT displays the metric collections that are currently generating errors.
Table 6-2 MGMT$METRIC_ERROR_CURRENT
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the metric collection error occurred. |
TARGET_TYPE |
VARCHAR2(64) |
Target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
GUID of the target for which the metric collection error occurred. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric for which the error occurred |
METRIC_LABEL |
VARCHAR2(64) |
User display name of the metric for which the error occurred. |
COLL_NAME |
VARCHAR2(256) |
Name of the collection collecting the metric for which the error occurred |
COLLECTION_TIMESTAMP |
DATE |
Time when the collection error occurred. |
ERROR_TYPE |
NUMBER |
Type of metric error. 0=Error 1=Warning |
ERROR_MESSAGE |
VARCHAR2(4000) |
Text of the error message. |
List the current metric errors for a given target.
List the current metric errors for a given target and metric.
Queries using this view would use index if target_name and target_type were specified.
MGMT$TARGET_COMPONENTS displays information about the software components that are associated with a managed target as well as details about where the software components have been installed.
Table 6-3 MGMT$TARGET_COMPONENTS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
Target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier (GUID) for the target. |
HOST_NAME |
VARCHAR2(64) |
The name of the host where the software homes are located. |
HOME_NAME |
VARCHAR2(64) |
The name for the location where the software is installed. This might be a user-supplied name or a name supplied by the Oracle Universal Installer. |
HOME_TYPE |
VARCHAR2(64) |
Three categories of homes are available: · ORACLE_HOME · APPL_TOP · INDEPENDENT · UNKNOWN |
HOME_LOCATION |
VARCHAR2(128) |
The file system path to the root of the home. |
COMPONENT_NAME |
VARCHAR2(128) |
The name of the software component. |
COMPONENT_ EXTERNAL_NAME |
VARCHAR2(128) |
The external name of the target, as specified during installation. |
COMPONENT_VERSION |
VARCHAR2(64) |
The current version of the software component. If the software component has been patched, this version number may be different than the base version number. |
COMPONENT_BASE_ VERSION |
VARCHAR2(64) |
Base version of the software component. |
SNAPSHOT_GUID |
RAW(16) |
GUID of the snapshot. |
This view can be used to identify the software components that are part of a specific managed target.
Access to this view will use an index if the query references the target name and target type, the home location, or the host name.
MGMT$BLACKOUT_HISTORY displays a historical log of changes in the blackout state for a managed target. In addition, the view can be used to generate a list of targets that were in a blackout period for a specific period of time.
Table 6-4 MGMT$BLACKOUT_HISTORY
Column | Datatype | Description |
---|---|---|
BLACKOUT_NAME |
VARCHAR(64) |
The name of the blackout. |
CREATED_BY |
VARCHAR(256) |
The Enterprise Manager administrator who created the blackout. |
BLACKOUT_GUID |
RAW(16) |
The unique global identifier (GUID) for the blackout. |
START_TIME |
DATE |
Start of the blackout period for the managed target. |
END_TIME |
DATE |
End of the blackout period for the managed target. If the target is currently in a blackout period, the END_ TIMESTAMP date will be NULL. |
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository. |
STATUS |
NUMBER(2) |
Current status of the blackout. Status Values: 0: Scheduled 1: Start Processing 2: Start Partial 4: Started 5: Stop Pending 6: Stop Failed 7: Stop Partial 8: Edit Failed 9: Edit Partial 10: Stopped 11: Ended 12: Partial Blackout 13: Modify Pending |
Queries using this view will use an index if they reference the target_name, target_ type, start_timestamp, or end_timestamp.
Typically, blackout history information retrieved using this view will be ordered by target_name, target_type, and start_timestamp.
MGMT$BLACKOUTS displays all blackout definition information along with current schedules.
Column | Datatype | Description |
---|---|---|
BLACKOUT_NAME |
VARCHAR(64) |
The name of the blackout. |
BLACKOUT_GUID |
RAW(16) |
The unique global identifier (GUID) of the blackout. |
REASON |
VARCHAR(64) |
Purpose of the blackout. Reasons are chosen from a predefined list by the report owner. |
DESCRIPTION |
VARCHAR2(2000) |
Detailed information about the blackout. |
STATUS |
NUMBER(2) |
Current status of the blackout. Status Values: 0: Scheduled 1: Start Processing 2: Start Partial 4: Started 5: Stop Pending 6: Stop Failed 7: Stop Partial 8: Edit Failed 9: Edit Partial 10: Stopped 11: Ended 12: Partial Blackout 13: Modify Pending |
CREATED_BY |
VARCHAR(256) |
Administrator who created the blackout. CREATED_BY returns SYSTEM as the blackout owner if the blackout was created using the Enterprise Manager Command Line Interface. |
LAST_START_TIME |
DATE |
Last time the blackout successfully started. |
LAST_END_TIME |
DATE |
Last time the blackout successfully ended. |
SCHEDULED_TIME |
NUMBER |
Possible values are: 0 - Immediate schedule 1 - Run once at specified time 2 - Run on interval 3 - Run daily 4 - Run on specified days of the week 5 - Run on specified days of the month 6 - Run on specified days of the year |
SCHEDULE_START_TIME |
DATE |
Time the blackout is scheduled to start. |
SCHEDULE_END_TIME |
DATE |
Time the blackout is scheduled to end. |
DURATION |
NUMBER |
Duration of the blackout in minutes. |
MGMT$ALERT_ANNOTATIONS displays a summary of alert annotations.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator |
TARGET_TYPE |
VARCHAR2(64) |
Target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier (GUID) for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric. |
METRIC_COLUMN |
VARCHAR2(64) |
If the metric defined at collection time is a TABLE type, the name of the column in the table that is represented by this metric is written to this field. The metric column is part of the primary key that uniquely identifies the value of this table that this metric represents. |
METRIC_LABEL |
VARCHAR2(64) |
Display name for the metric. |
COLUMN_LABEL |
VARCHAR2(64) |
Display name for the column of a TABLE metric. |
KEY_VALUE |
VARCHAR2(256) |
Key value of the alert violation. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key. |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key. |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key. |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key. |
MESSAGE |
VARCHAR2(4000) |
The metric severity message. |
ALERT_STATE |
VARCHAR2(20) |
A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. An alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Warning · Critical |
COLLECTION_ TIMESTAMP |
DATE |
Date and time when the alert condition was detected by the Management Agent. |
ANNOTATION_MESSAGE |
VARCHAR2(4000) |
Annotation text. |
ANNOTATION_TIMESTAMP |
DATE |
Time the annotation was created. |
ANNOTATED_BY |
VARCHAR2(64) |
Enterprise Manager administrator who authored the the annotation. |
SOURCE_OBJ_GUID |
RAW(16) |
Unique global identifier (GUID) of the metric severity associated with this annotation. |
MGMT$ALERT_NOTIF_LOG displays a summary of alert notifications.
Table 6-7 MGMT$MGMT$ALERT_NOTIF_LOG
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier (GUID) for the target. |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if the table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
A intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains a user understandable display name for the metric column. |
KEY_VALUE |
VARCHAR2(256) |
For table metrics, this column contains the value of the key column for the row in the table whose thresholds are being defined. If the thresholds are not for a table metric, or the thresholds apply for all rows in the metric column, then the value in this column will contain a single space. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key. |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key. |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key. |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key. |
MESSAGE |
VARCHAR2(4000) |
An optional message that is generated when the alert is created that provides additional information about the alert condition. |
ALERT_STATE |
VARCHAR2(20) |
A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. A alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Warning · Critical |
COLLECTION_ TIMESTAMP |
DATE |
Date and time when the alert condition was detected by the Management Agent. |
DELIVERY_MESSAGE |
VARCHAR2(1024) |
Message indicating the success or failure of the notification delivery. |
DELIVERY_TIMESTAMP |
DATE |
Time at which the log message was created. |
SOURCE_OBJ_GUID |
RAW(16) |
Unique global identifer (GUID) of the metric severity associated with this delivery message. |
MGMT$TARGET_METRIC_COLLECTIONS displays information about the metric collections.
Table 6-8 MGMT$TARGET_METRIC_COLLECTIONS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
Unique global identifier (GUID) for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if the table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_GUID |
RAW(16) |
Unique global identifier (GUID) for the metric. This ID can be used to associate metric information with metric data information during reporting. |
COLLECTION_NAME |
VARCHAR2(64) |
The name of the collection. |
IS_ENABLED |
NUMBER(1) |
Indicates whether the collection is currently enabled. 0=not enabled 1=enabled. |
IS_REPOSITORY |
NUMBER(1) |
Indicates whether this is a repository-side collection. A repository-side collection has a PL/SQL evaluation procedure that is responsible for calculating the metric values. |
FREQUENCY_CODE |
NUMBER |
The metric collection frequency type. Possible values are: 1: One Time 2: Interval 3: Daily 4: Weekly 5: Monthly 6: Yearly 7: On Demand |
COLLECTION_FREQUENCY |
VARCHAR2 |
Frequency of the metric collection. Value displayed is dependent on the frequency code: ² For One Time, the start date-time is stored in DD-MON-YY HH24:MI format. ² For Interval type, the frequency in minutes is stored. ² For Daily/Weekly/Monthly/Yearly types, the hour and minute of collection is stored in HH24:MI format. ² For On-Demand type, On-Demand is stored. |
UPLOAD_POLICY |
NUMBER |
The frequency with which the metric data is uploaded/stored. |
List the metric collections for a given target.
MGMT$TARGET_METRIC_SETTINGS displays information about the current metric setting stored for all targets in the Management Repository. This view provides information for both agent-side and repository-side metrics.
Table 6-9 MGMT$TARGET_METRIC_SETTINGS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier (GUID) for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if the table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_GUID |
RAW(16) |
The unique global identifier for the metric. This ID can be used to associate metric information with metric data information during reporting. |
COLLECTION_NAME |
VARCHAR2(64) |
The name of the collection. |
CATEGORY |
VARCHAR2(64) |
The name of the category the metric.Refer to MGMT$METRIC_CATEGORIES for the list of all metric categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value of the metric setting. For composite keys, this is the first part of the key.If the thresholds are not for a table metric, or the thresholds apply for all rows in the metric column, then the value in this column will contain a single space. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key. |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key. |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key. |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key. |
KEY_OPERATOR |
NUMBER |
Specifies whether the key_value columns have any SQL wildcards.For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise.For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column. |
HAS_ACTIVE_BASELINE |
NUMBER(1) |
The is a flag that specifies that the metric rows with this key_value has an active baseline and any user updates to thresholds/parameter values should be ignored. |
PREVENT_OVERRIDE |
NUMBER(1) |
The is a flag that specifies that the metric rows with this key_value has a template override flag. Once the template override flag is ON, any template application will not update the threshold/parameter values. |
WARNING_OPERATOR |
NUMBER |
Defines the warning threshold condition to be applied 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression |
WARNING_THRESHOLD |
VARCHAR2(256) |
The warning threshold value. |
CRITICAL_OPERATOR |
NUMBER |
Defines the critical threshold condition to be applied. 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression |
CRITICAL_THRESHOLD |
VARCHAR2(256) |
The critical threshold value. |
OCCURRENCE_COUNT |
NUMBER |
The number of times the test has to trigger to raise a violation. |
WARNING_ACTION_TYPE |
VARCHAR2(32) |
Specifies the job type of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
WARNING_ACTION_JOB_OWNER |
VARCHAR2(256) |
Specifies the job owner of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ |
WARNING_ACTION_JOB_NAME |
VARCHAR2(64) |
Specifies the job name of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ |
CRITICAL_ACTION_TYPE |
VARCHAR2(17) |
The critical corrective action type configured. Possible values are :No-Action : when no action is configuredCorrective-Action : when a repository side corrective action is configuredAgent-Fixit Job : when an agent side fix-it job is configured. |
CRITICAL_ACTION_JOB_TYPE |
VARCHAR2(32) |
Specifies the job type of the critical corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
CRITICAL_ACTION_JOB_OWNER |
VARCHAR2(256) |
Specifies the job owner of the critical corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
CRITICAL_ACTION_JOB_NAME |
VARCHAR2(64) |
Specifies the job name of the critical corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
List all the metric setting for a given target.
List the metric settings for a given target and metric.
List the corrective actions assigned for a given target-metric.
MGMT$AVAILABILITY_CURRENT displays information about the most recent target availability information stored in the Management Repository.
Table 6-10 MGMT$AVAILABILITY_CURRENT
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
START_TIMESTAMP |
DATE |
The time when the target availability status change was first detected. |
AVAILABILITY_STATUS |
VARCHAR(15) |
Current target availability status. This column contains one of the following values:² Target Down² Target Up² Metric Error² Agent Down² Unreachable² Blackout² Pending/Unknown |
Get the current availability status of a given target.
MGMT$AVAILABILITY_HISTORY displays detailed historical information about changes in the availability status for a target over time.
Table 6-11 MGMT$AVAILABILITY_HISTORY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
START_TIMESTAMP |
DATE |
The time when the target availability status change was first detected. |
END_TIMESTAMP |
DATE |
The time when the target availability status change was last detected. |
AVAILABILITY_STATUS |
VARCHAR2(10) |
Target availability status. This column will contain one of the following values:² Target Down² Target Up² Metric Error² Agent Down² Unreachable² Blackout² Pending/Unknown |
Access to this view will use an index if the query references the member TARGET_ NAME, TARGET_TYPE and the START_TIMESTAMP.
MGMT$ALERT_CURRENT displays current information for any alerts that are logged in the Management Repository that are in a non-clear state. Only the most recent open alert in a non-clear status for a given metric will be displayed through this view.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
VIOLATION_GUID |
RAW(16) |
Unique identifier for the alert. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
An intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains an intuitive display name for the metric column. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
COLLECTION_ TIMESTAMP |
DATE |
The date-time when the alert condition was detected by the Management Agent. |
ALERT_STATE |
VARCHAR2(20) |
A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. A alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings:· Warning· CriticalIf the metric's alert condition goes into a clear state, it will no longer be visible from this view. |
VIOLATION_TYPE |
VARCHAR2(19) |
A user readable description of the type of violation. Possible values are : Threshold Violation, when the alert is triggered based on a metric thresholdAvailability, when the alert is triggered for an availability metricPolicy Violation, when the alert is triggered based on a policy violation. |
MESSAGE |
VARCHAR2(1024) |
An optional message that is generated when the alert is created that provides additional information about the alert condition. |
MESSAGE_NLSID |
VARCHAR2(64) |
The NLSID of the alert message |
MESSAGE_PARAMS |
VARCHAR2(4000) |
Contains the URL encoded parameters separated by "&" to be used to format the alert message. |
ACTION_MESSAGE |
VARCHAR2(4000) |
Suggested action message in english for this alert |
ACTION_MESSAGE_NLSID |
VARCHAR2(64) |
The NLS ID of the action message. |
ACTION_MESSAGE_PARAMS |
VARCHAR2(4000) |
Contains the URL encoded parameters for translating action message |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
The display name of the target type |
List the current alerts that are in a non-clear state for a metric, set of metrics, or for a managed target. If the user is only interested in non-clear alerts, counts or selects, using this view provide better performance than using the MGMT$ALERT_DETAILS view.
Access to this view will use an index if the query references the member target name, target type, metric name, and metric column or a subset of these columns if they are included as listed above from left to right.
MGMT$ALERT_HISTORY displays historical information for any alerts that are logged in the Management Repository.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
VIOLATION_GUID |
RAW(16) |
Unique identifier for the alert. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
An intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains an intuitive display name for the metric column. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
COLLECTION_ TIMESTAMP |
DATE |
The date-time when the alert condition was detected by the Management Agent. |
ALERT_STATE |
VARCHAR2(20) |
A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. A alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings:· Warning· CriticalIf the metric's alert condition goes into a clear state, it will no longer be visible from this view. |
ALERT_DURATION |
NUMBER |
The time, in hours, from when the alert condition was first detected until it was cleared. |
MESSAGE |
VARCHAR2(1024) |
An optional message that is generated when the alert is created that provides additional information about the alert condition. |
MESSAGE_NLSID |
VARCHAR2(64) |
The NLSID of the alert message |
MESSAGE_PARAMS |
VARCHAR2(4000) |
Contains the URL encoded parameters separated by "&" to be used to format the alert message. |
ACTION_MESSAGE |
VARCHAR2(4000) |
Suggested action message in english for this alert |
ACTION_MESSAGE_NLSID |
VARCHAR2(64) |
The NLS ID of the action message. |
ACTION_MESSAGE_PARAMS |
VARCHAR2(4000) |
Contains the URL encoded parameters for translating action message |
VIOLATION_TYPE |
VARCHAR2(19) |
An intuitive description of the type of violation. Possible values are : Threshold Violation: When the alert is triggered based on a metric thresholdAvailability: When the alert is triggered for an availability metricPolicy Violation: When the alert is triggered based on a policy violation. |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
The display name of the target type |
List the historical details of alerts for a managed target or a specific metric ordered by time.
Determine the notification status for a specific alert or set of alerts.
Generate statistical reports on alert frequency using criteria such as by target, by metric, by groups of metrics.
Custom implementation of event filtering or causal analysis.
Custom aggregation (grouping) of alert information into categories.
Custom alert status queries or aggregations for specific time periods. i.e. What was my most problematic metric for target x last week? How many times did alert y occur between times w and x?
Generating time based histograms of alerts.
The view does not force any specific order on the rows returned. The assumption is that if the user wants to order the alert records that are returned in a specific way, they will add an order by clause to their select query.
Access to this view will use an index if the query references the member target name, target type, metric name, and metric column or a subset of these columns if they are included as listed above from left to right.
Queries that use the collection_timestamp or that query using the alert_state will also be indexed.
MGMT$METRIC_DETAILS displays a rolling 25 hour window of individual metric samples. These are the metric values for the most recent sample that has been loaded into the Management Repository plus any earlier samples that have not been aggregated into hourly statistics.
Table 6-14 MGMT$METRIC_DETAILS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_TYPE |
VARCHAR2(20) |
A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values:NumberStringTableRawExternal |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
An intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains an intuitive display name for the metric column. |
COLLECTION_ TIMESTAMP |
DATE |
The date-time when the alert condition was detected by the Management Agent. |
VALUE |
VARCHAR2(4000) |
Since current metric values can be a numeric or a string type, this column returns the value of the metric as a string. If the user of the view is restricting the query to numeric metric values, they can use the TO_NUMBER SQL function to return the values in numeric form. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
Show the individual values for a metric over time.
Identify time periods when abnormal samples for metric were collected.
Calculate the correlation coefficient between two or more metrics.
Provide metric values that are associated with an alert.
Queries using this view will use an index if the queries use the target name, the target type, metric name. metric column, and key value, or if they are based upon the collection_timestamp.
MGMT$METRIC_CURRENT displays information on the most recent metric values that have been loaded into the Management Repository.
Table 6-15 MGMT$METRIC_CURRENT
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_TYPE |
VARCHAR2(20) |
A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values:NumberStringTableRawExternal |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
An intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains an intuitive display name for the metric column. |
COLLECTION_ TIMESTAMP |
DATE |
The date-time when the alert condition was detected by the Management Agent. |
VALUE |
VARCHAR2(4000) |
Since current metric values can be a numeric or a string type, this column returns the value of the metric as a string. If the user of the view is restricting the query to numeric metric values, they can use the TO_NUMBER SQL function to return the values in numeric form. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
Retrieve the most recent value for a metric that is stored in the Management Repository.
Retrieve the latest metrics for a target or metric for a specific time period.
Queries using this view will use an index if the queries use target name, the target type, metric name. metric column, and key value, or if they are based upon the collection_timestamp.
MGMT$METRIC_HOURLY displays metric statistics information that have been aggregated from the individual metric samples into hourly time periods. For example, if a metric is collected every 15 minutes, the 1 hour rollup would aggregate the 4 samples into a single hourly value by averaging the 4 individual samples together. The current hour of statistics may not be immediately available from this view. The timeliness of the information provided from this view is dependent on when the query against the view was executed and when the hourly rollup table was last refreshed.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
An intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains an intuitive display name for the metric column. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
ROLLUP_TIMESTAMP |
DATE |
The rollup timestamp identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period. |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
This view provides the best level of granularity to show changes in a metric's value over the course of a day.
Identify hourly time periods when a metric or sets of metrics are maximized.
Understand how the variability of a metric over a one hour time period.
Identify the values of the collected metrics for a target when a particular hour has been identified as problematic.
Queries using this view will use an index if the queries use the target_name, the metric_name, or if they are based upon the rollup_timestamp.
MGMT$METRIC_DAILY displays metric statistics that have been aggregated from the samples collected over the previous twenty-four hour time period. The timeliness of the information provided from this view is dependent on when the query against the view was executed and when the hourly rollup table was last refreshed.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
METRIC_LABEL |
VARCHAR2(64) |
An intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains an intuitive display name for the metric column. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
ROLLUP_TIMESTAMP |
DATE |
The rollup timestamp identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period. |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
View provides the best granularity to show changes in a metric's value over the course of a week or month.
Understand trends in metric values.
Queries using this view will use an index if the queries use the target_name, the metric_name, or if they are based upon the rollup_timestamp.
MGMT$TARGET displays information about the managed targets that are known to the Management Repository. These targets may or may not be actively monitored.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target. Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
TYPE_VERSION |
VARCHAR2(8) |
The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control. |
TYPE_QUALIFIER1-5 |
VARCHAR2(64) |
Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or RAC configuration. |
EMD_URL |
VARCHAR2(2000) |
The URL address of the Management Agent that is managing the target. |
TIMEZONE_REGION |
VARCHAR2(64) |
The timezone region in which the target operates. |
DISPLAY_NAME |
VARCHAR2(64) |
User-friendly name for the target. |
HOST_NAME |
VARCHAR2(128) |
Name of the host where the target is running. For composite targets or targets that span a host, this column will be NULL. |
LAST_METRIC_LOAD_TIME |
TIMESTAMP |
Timestamp when information for this target was last loaded into the Management Repository. If metrics have not been loaded into the Management Repository for the target, this column will be NULL. |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
User-friendly name of the target type. |
Display a list of the targets known to the Management Repository.
Display administration and monitoring information in the context of a managed target.
Order the targets by last load time for customers to get a sense on how recent the information is for a target in the Management Repository. To access this information in an ordered way, customers should use the appropriate ORDER BY clause with the view.
Access to this view will use an index if the query references the target name and target type.
There is an implicit assumption that customers will not use this view to identify the targets that are owned by a Management Agent or the targets that reside on a specific host.
MGMT$TARGET_TYPE displays metric descriptions for a given target name and target type. This information is available for the metrics for the managed targets that have been loaded into the Management Repository. Metrics are specific to the target type.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
TYPE_VERSION |
VARCHAR2(8) |
The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control. |
TYPE_QUALIFIER1-5 |
VARCHAR2(64) |
Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or RAC configuration. |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric that is being defined. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space. For example, if a table describing the MGMT$TARGET_TYPE view is to be defined as a table metric, Column Name, Data Type, and Description would be metric columns. |
KEY_COLUMN |
VARCHAR2(64) |
For table metrics, the key column contains the name of the column in the table that represents the primary key. Values in this column must uniquely identify rows in the table. If the metric that is being defined is not a table metric, the value in this column is a single space; For example, the Column Name would be the key column if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric. |
METRIC_TYPE |
VARCHAR2(20) |
A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values: Number String Table Raw External Repository Metric |
METRIC_LABEL |
VARCHAR2(64) |
A intuitive display name for the metric that is being defined. |
COLUMN_LABEL |
VARCHAR2(64) |
For table metrics, the column label contains a user understandable display name for the metric column. |
DESCRIPTION |
VARCHAR2(128) |
A description of the metric that is being defined. |
DESCRIPTION_NLSID |
VARCHAR2(64) |
The NLSid of the description of the metric |
UNIT |
VARCHAR2(32) |
The unit of the metric that is being defined. |
UNIT_NLSID |
VARCHAR2(64) |
The NLSid of the unit of the metric being defined. |
SHORT_NAME |
VARCHAR2(40) |
This is a shortened version of the metric display name for the "dense" UI concept |
SHORT_NAME_NLSID |
VARCHAR2(64) |
The NLSid of the short name of the metric being defined. |
List the set of metrics that have been defined for a target type.
Display intuitive metric names and associated attributes such as unit in a general way during portal, web application, or custom 4GL report generation.
Access to this view will use an index if the query references the metric name, metric column. The query should also qualify the target name and target type in order to restrict the amount of information returned.
MGMT$TARGET_TYPE_DEF displays definition information for a target type.
Table 6-20 MGMT$TARGET_TYPE_DEF
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
User-friendly name of the target type. |
TARGET_TYPE_GUID |
RAW(16) |
The unique global identifier (GUID) of the target type . |
MAX_TYPE_META_VER |
VARCHAR2(8) |
The maximum version of the target type stored in the Management Repository. |
MGMT$TARGET_ASSOCIATIONS displays the various associations between targets. This view can be used to find all types of associations for a given target.
Table 6-21 MGMT$TARGET_ASSOCIATIONS
Column | Datatype | Description |
---|---|---|
ASSOC_DEF_NAME |
VARCHAR2(64) |
Name of the association definition. |
SOURCE_TARGET_NAME |
VARCHAR2(256) |
Target name of the target to which the association is being defined. |
SOURCE_TARGET_TYPE |
VARCHAR2(64) |
The target type of the target for which the association is being defined. ÒANYÓ can be used to specify that any target type be used. |
ASSOC_TARGET_NAME |
VARCHAR2(256) |
Target Name of the target which is being associated with the source target. |
ASSOC_TARGET_TYPE |
VARCHAR2(64) |
The target type of the associated target. ÒANYÓ can be used to specify that any target type be used. |
SCOPE_TARGET_NAME |
VARCHAR2(256) |
The target under whose scope the association is valid. This applies to non-global associations only. For example: A database may be part of a composite target only for a particular service. |
SCOPE_TARGET_TYPE |
VARCHAR2(64) |
The target type for which the association is valid. This applies to non-global associations only. |
ASSOCIATION_TYPE |
VARCHAR2(64) |
The type of association. |
Can be used to list the associations defined for a specific target.
Queries using this view will use an index if either (source_target_name, source_target_type) or (assoc_target_name, assoc_target_type) is specified.
MGMT$TARGET_MEMBERS displays the list of direct members for a target.
Table 6-22 MGMT$TARGET_MEMBERS
Column | Datatype | Description |
---|---|---|
AGGREGATE_TARGET_NAME |
VARCHAR2(256) |
Target name of the aggregate target. |
AGGREGATE_TARGET_TYPE |
VARCHAR2(64) |
Target type of the aggregate target. |
AGGREGATE_TARGET_GUID |
RAW(16) |
Target GUID of the aggregate target. |
MEMBER_TARGET_NAME |
VARCHAR2(256) |
Target Name of the member target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
Target type of the member target. |
MEMBER_TARGET_GUID |
RAW(16) |
Target GUID of the member target. |
Find the members for a aggregate target.
Find the aggregate targets for which a given target is a direct member.
Queries, which specify values for (AGGREGATE_TARGET_NAME, AGGREGATE_TARGET_TYPE) or (MEMBER_TARGET_NAME, MEMBER_TARGET_TYPE) will use index.
Joins using AGGREGATE_TARGET_GUID and MEMBER_TARGET_GUID will be efficient.
MGMT$TARGET_FLAT_MEMBERS displays the list of all direct and indirect members of the target.
Table 6-23 MGMT$TARGET_FLAT_MEMBERS
Column | Datatype | Description |
---|---|---|
AGGREGATE_TARGET_NAME |
VARCHAR2(256) |
The target name of the aggregate target |
AGGREGATE_TARGET_TYPE |
VARCHAR2(64) |
The target type of the aggregate target |
AGGREGATE_TARGET_GUID |
RAW(16) |
Target GUID of the aggregate target |
MEMBER_TARGET_NAME |
VARCHAR2(256) |
Target Name of the member target |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
Target type of the member target |
MEMBER_TARGET_GUID |
RAW(16) |
Target GUID of the member target |
Find the members for a aggregate target.
Find the aggregate targets for which a given target is a member either directly or indirectly.
Queries, which specify values for (AGGREGATE_TARGET_NAME, AGGREGATE_TARGET_TYPE) or (MEMBER_TARGET_NAME, MEMBER_TARGET_TYPE) will use index.
Joins using AGGREGATE_TARGET_GUID and MEMBER_TARGET_GUID will be the most efficient on this view.
MGMT$TARGET_TYPE_PROPERTIES displays the default list of properties that are applicable to the target based on the target type to which the target belongs.
Table 6-24 MGMT$TARGET_TYPE_PROPERTIES
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target. |
TARGET_TYPE |
VARCHAR2(64) |
Name of the target type. |
PROPERTY_NAME |
VARCHAR2(64) |
Name of the property, Example:is_aggregate,is_service, IsBaselineable. |
PROPERTY_VALUE |
VARCHAR2(1024) |
Value of the property |
List the properties applicable to the target and the default values.
MGMT$TARGET_PROPERTIES displays detailed target properties.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
PROPERTY_NAME |
VARCHAR2(64) |
The name of the target property being defined. |
PROPERTY_VALUE |
VARCHAR2(1024) |
The value of the target property being defined. |
PROPERTY_TYPE |
VARCHAR2(64) |
The type of the target property being defined. Possible values are: INSTANCE, if the property is applicable to the target instance. DYNAMIC, if the property is calculated dynamically. |
MGMT$METRIC_CATEGORIES displays the list of classes and categories to which the metric belongs. This view can be used to classify the metric based on the class (Example: Service, Functional) and category within the class (Example: security/configuration under functional class or usage/performance under service class).
Table 6-26 MGMT$METRIC_CATEGORIES
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
Name of the target type. |
TYPE_VERSION |
VARCHAR2(8) |
Version of the target type. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric. |
METRIC_COLUMN |
VARCHAR2(64) |
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, the value in this column is a single space. |
METRIC_CLASS_NAME |
VARCHAR2(64) |
Name of the metric class to which this metric belongs. |
METRIC_CATEGORY_NAME |
VARCHAR2(64) |
Name of the category of the metric in the class. |
METRIC_CATEGORY_NLSID |
VARCHAR2(64) |
The NLS ID of the category which is used by Enterprise Manager to translate the name to different languages. |
Classify the metrics into different buckets based on Class and category.
MGMT$POLICIES displays the list of policies defined in the Management Repository.
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and polciies that are applicable for the target. |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric based on which the policy is defined. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy being defined. |
POLICY_LABEL_NLSID |
VARCHAR2(64) |
The NSL ID for the policy name. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
AUTHOR |
VARCHAR2(256) |
The author of the policy. |
DESCRIPTION |
VARCHAR2(256) |
The description of the policy. |
DESCRIPTION_NLSID |
VARCHAR2(64) |
The NLS ID of the description. |
IMPACT |
VARCHAR2(500) |
A description of th e impact of the policy being defined. |
IMPACT_NLSID |
VARCHAR2(64) |
NLSid for the policy impact. |
RECOMMENDATION |
VARCHAR2(500) |
A recommendation for the policy being defined. |
RECOMMENDATION_NLSID |
VARCHAR2(64) |
NLS ID for the policy recommendataion. |
VIOLATION_LEVEL |
VARCHAR2(13) |
The level at which the violations will be logged when the policy being defined is violated. Possible values are : Informational Warning Critical |
CONDITION_TYPE |
NUMBER(1) |
The type condition used by the the policy being defined. Possible values are : 1. Simple condition 2. SQL expression condition 3. PL/SQL procedure for evaluating condition. |
CONDITION |
VARCHAR2(4000) |
The conidtion details / expression used by the policy being defined. If the condition type is 1, this column contains the metric_column_name 2, this column contains the conditional expression 3, this column contains the pl/sql procedure name that peforms the condition. |
CONDITION_OPERATOR |
NUMBER |
Defines the policy condition operator to be applied, when the condition_type is 'Simple Condition'. Possible values are : 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression |
OWNER |
VARCHAR2(256) |
The Enterprise Manager administrator who created the policy in the repository. |
AUTO_ENABLED |
NUMBER(1) |
Specifies whether the policy should be enable automatically on the new targets that are being added. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
CATEGORY_NLSID |
VARCHAR2(64) |
The NLSid of the policy category. |
MGMT$POLICY_PARAMETERS displays detailed information about a policy.
Table 6-28 MGMT$POLICY_PARAMETERS
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and polciies that are applicable for the target. |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric based on which the policy is defined. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy being defined. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
PARAMETER_NAME |
VARCHAR2(64) |
The name of the policy parameter |
PARAMETER_NAME_NLSID |
VARCHAR2(64) |
The NLSid of the policy parameter. |
PARAMETER_TYPE |
VARCHAR2(7) |
The type of the policy parameter. Possible values are : 1 for NUMERIC parameter 2 for STRING parameter |
MGMT$POLICY_VIOLATION_CTXT displays the policy violation context.
Table 6-29 MGMT$POLICY_VIOLATION_CTXT
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and polciies that are applicable for the target |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric based on which the policy is defined. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy being defined. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
COLUMN_NAME |
VARCHAR2(64) |
The column name to be included in the policy violation context. |
IS_HIDDEN |
NUMBER(1) |
Flag indicating whether or not the value for this metric (data source) column should be displayed when viewing a violation. Default 0. |
URL_LINK_TYPE |
VARCHAR2(7) |
Flag indicating the type of the link. Possible values : JSP UIX |
URL_LINK_TEMPLATE |
VARCHAR2(4000) |
URL template that contains references to any metric (data source) column name defined in the metric (data source). The actual values are substituted in at run-time to construct a URL that is associated with this metric columns value. Default NULL. |
MGMT$TARGET_POLICY_EVAL_SUMM displays the policy violation summary for a target.
Table 6-30 MGMT$TARGET_POLICY_EVAL_SUMM
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target.. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy for which evaluation summary is provided. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
COLL_NAME |
VARCHAR2(64) |
The name of the collection on which the policy is evaluated. |
LAST_EVALUATION_DATE |
DATE |
The last date on which the policy was evaluated for the target for the collection item. |
TOTAL_VIOLATIONS |
NUMBER |
The number of violations logged for the given target policy association |
NON_SUPPRESS_VIOLATIONS |
NUMBER |
The number of non-exempt violations logged for the given target policy association. |
COMPLIANCE_SCORE |
NUMBER |
The compliance score calculated for the target policy association. |
MGMT$POLICY_VIOL_ANNOTATIONS displays a summary of policy violation annotations.
Table 6-31 MGMT$POLICY_VIOL_ANNOTATIONS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy rule |
DESCRIPTION |
VARCHAR2(256) |
A description of the policy rule |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
MESSAGE |
VARCHAR2(4000) |
The policy violation message. |
VIOLATION_LEVEL |
VARCHAR2(40) |
A user readable description of the internal violation code that is sent from the Management Agent to identify the state of the policy violation. A policy violation record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Critical |
COLLECTION_TIMESTAMP |
DATE |
The date-time when the policy violation was detected by the Management Agent. |
ANNOTATION_MESSAGE |
VARCHAR2(4000) |
The annotation text. |
ANNOTATION_TIMESTAMP |
DATE |
The time the annotation was created. |
ANNOTATED_BY |
VARCHAR2(256) |
Enterprise Manager administrator who authored the the annotation. |
MGMT$POLICY_VIOL_NOTIF_LOG displays details of notification deliveries for policy violations.
Table 6-32 MGMT$POLICY_VIOL_NOTIF_LOG
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy rule |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
VIOLATION_MESSAGE |
VARCHAR2(4000) |
A user readable description of the internal violation code that is sent from the Management Agent to identify the state of the policy violation. A policy violation record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Critical |
VIOLATION_LEVEL |
VARCHAR2(40) |
A user readable description of the internal violation code that is sent from the Management Agent to identify the state of the policy violation. A policy violation record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Critical |
COLLECTION_TIMESTAMP |
DATE |
The date-time when the policy violation was detected by the Management Agent. |
DELIVERY_MESSAGE |
VARCHAR2(1024) |
The message indicating the success or failure of the notification delivery. |
DELIVERY_TIMESTAMP |
DATE |
The date-time when the notification was delivered. |
MGMT$TARGET_POLICIES displays target policy information.
Table 6-33 MGMT$TARGET_POLICIES
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy that is associated with the target. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
IS_ENABLED |
NUMBER(1) |
Flag to indicate whether the policy is enabled or disabled on the target. |
MGMT$TARGET_POLICY_SETTINGS displays policy settings for a target.
Table 6-34 MGMT$TARGET_POLICY_SETTINGS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy that is associated with the target. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
KEY_OPERATOR |
NUMBER |
Specifies whether the key_value columns have any SQL wildcards. For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise. For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column |
PARAMETER_NAME |
VARCHAR2(64) |
The name of the policy parameter. |
PREVENT_OVERRIDE |
NUMBER(1) |
The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values. |
POLICY_THRESHOLD |
VARCHAR2(256) |
The threshold value for the policy parameter. |
ACTION_TYPE |
VARCHAR2(17) |
The corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an agent side fix-it job is configured. |
ACTION_JOB_TYPE |
VARCHAR2(32) |
Specifies the job type of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ. |
ACTION_JOB_NAME |
VARCHAR2(64) |
Specifies the job name of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ. |
ACTION_JOB_OWNER |
VARCHAR2(256) |
Specifies the job owner of the corrective action when ACTION_TYPR is ÒCorrective-ActionÓ. |
MGMT$POLICY_VIOLATION_CURRENT displays current information for any policy violations that are logged in the Management Repository that are in a non-clear state. Only the most recent open violation in a non-clear status for a given policy will be provided through this view.
Table 6-35 MGMT$POLICY_VIOLATION_CURRENT
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
User-friendly name of the target type. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy that is associated with the target. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
COLLECTION_TIMESTAMP |
DATE |
The date-time when the policy violation condition was detected. |
VIOLATION_LEVEL |
NUMBER |
A user readable description of the internal violation level logged to identify the state of the policy condition. A violation record is logged each time the policy condition is violated in either direction. The value of this column will contain one of the following strings: . Informational · Warning · Critical If the policy condition goes into a clear state, it will no longer be visible from this view. |
MESSAGE |
VARCHAR2(4000) |
An optional message that is generated when the violation is logged that provides additional information about the policy condition. |
MESSAGE_NLSID |
VARCHAR2(64) |
The NLSid of the message. |
MESSAGE_PARAMS |
VARCHAR2(4000) |
Contains the URL encoded parameters separated by "&" to be used to format the alert message. |
SUPPRESS_CODE |
NUMBER |
Indication of exemption status. Legal values: 0 - not exempt 1 - exempt indefinitely 2 - exempt until date specified in SUPPRESS_UNTIL 3 - exempt until next evaluation Default 0' |
SUPPRESS_UNTIL |
DATE |
Specifies the date until which exemption should be applied. Only application if SUPPRESS_CODE is 2 |
SUPPRESS_BY |
VARCHAR2(256) |
Enterprise Manager adminstrator that suppressed the violation. |
MGMT$POLICY_VIOLATION_HISTORY displays historical information for any policies that are logged in the Management Repository.
Table 6-36 MGMT$POLICY_VIOLATION_HISTORY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
User-friendly name of the target type. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy that is associated with the target. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
COLLECTION_TIMESTAMP |
DATE |
The date-time when the policy violation condition was detected. |
VIOLATION_LEVEL |
NUMBER |
A user readable description of the internal violation level logged to identify the state of the policy condition. A violation record is logged each time the policy condition is violated in either direction. The value of this column will contain one of the following strings: . Informational · Warning · Critical If the policy condition goes into a clear state, it will no longer be visible from this view. |
VIOLATION_DURATION |
NUMBER |
The time, in hours, from when the policy condition was first detected until it was cleared. |
MESSAGE |
VARCHAR2(4000) |
An optional message that is generated when the violation is logged that provides additional information about the policy condition. |
MESSAGE_NLSID |
VARCHAR2(64) |
NLSid of the policy message. |
MESSAGE_PARAMS |
VARCHAR2(4000) |
Contains the URL encoded parameters separated by "&" to be used to format the policy message. |
MGMT$POLICY_VIOLATION_CONTEXT displays policy violation context.
Table 6-37 MGMT$POLICY_VIOLATION_CONTEXT
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TYPE_DISPLAY_NAME |
VARCHAR2(128) |
User-friendly name of the target type. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy that is associated with the target. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
COLLECTION_TIMESTAMP |
DATE |
The date-time when the policy violation condition was detected. |
COLUMN_NAME |
VARCHAR2(64) |
The associated name stored along with the policy violation. |
COLUMN_VALUE |
VARCHAR2(4000) |
The associated value stored along with the policy violation. |
MGMT$TEMPLATES displays details of all the management templates stored in the Management Repository.
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TEMPLATE_NAME |
VARCHAR2(64) |
The name of the template. |
TEMPLATE_GUID |
RAW(16) |
The unique global identifier for the template. |
DESCRIPTION |
VARCHAR2(1024) |
The description of the template. |
OWNER |
VARCHAR2(256) |
Enterprise Manager administrator who owns the template. |
IS_PUBLIC |
NUMBER(1) |
The flag to specify whether the template is accessible to all EM administrators. |
CREATED_DATE |
DATE |
The date/time when the template is created in the repository. |
LAST_UPDATED_DATE |
DATE |
The date/time when the template was last modified in the repository. |
LAST_UPDATED_BY |
VARCHAR2(256) |
The EM administrator who last updated the template. |
MGMT$TEMPLATE_POLICY_SETTINGS displays policy settings for management templates.
Table 6-39 MGMT$TEMPLATE_POLICY_SETTINGS
Column | Datatype | Description |
---|---|---|
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TEMPLATE_NAME |
VARCHAR2(64) |
The name of the template. |
TEMPLATE_GUID |
RAW(16) |
The unique global identifier for the template. |
POLICY_NAME |
VARCHAR2(128) |
The name of the policy that is associated with the template. |
POLICY_GUID |
RAW(16) |
The unique global identifier for the policy. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
KEY_OPERATOR |
NUMBER |
Specifies whether the key_value columns have any SQL wildcards. For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise. For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column |
PARAMETER_NAME |
VARCHAR2(64) |
The name of the parameter. |
PREVENT_OVERRIDE |
NUMBER(1) |
The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values. |
POLICY_THRESHOLD |
VARCHAR2(256) |
The threshold value confugured for the policy parameter. |
ACTION_TYPE |
VARCHAR2(17) |
The corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an agent side fix-it job is configured. |
ACTION_JOB_TYPE |
VARCHAR2(32) |
Specifies the job type of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ. |
ACTION_JOB_NAME |
VARCHAR2(64) |
Specifies the job name of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ. |
ACTION_JOB_OWNER |
VARCHAR2(256) |
Specifies the job owner of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ. |
MGMT$TEMPLATE_METRICCOLLECTIONS displays information on the metric collections defined for a template.
Table 6-40 MGMT$TEMPLATE_METRICCOLLECTION
Column | Datatype | Description |
---|---|---|
TEMPLATE_NAME |
VARCHAR2(64) |
The name of the template. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TEMPLATE_GUID |
RAW(16) |
The unique global identifier for the template. |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric for which the template collection is configured. |
METRIC_COLUMN |
VARCHAR2(64) |
The name of the metric column for which the template collection is configured. |
METRIC_GUID |
RAW(16) |
The unique global identifier for the metric column. |
COLLECTION_NAME |
VARCHAR2(64) |
The name of the collection. |
IS_REPOSITORY |
NUMBER(1) |
Indicates whether this is a repository-side collection. A repository-side collection has a PL/SQL evaluation procedure that is responsible for calculating the metric values. |
FREQUENCY_CODE |
VARCHAR2(9) |
The metric collection frequency type. Possible values are: 1: One Time 2: Interval 3: Daily 4: Weekly 5: Monthly 6: Yearly 7: On Demand |
COLLECTION_FREQUENCY |
VARCHAR2(81) |
The frequency of the metric collection. Value displayed is dependent on the frequency code: For One Time, the start date-time is stored in DD-MON-YY HH24:MI format. For Interval type, the frequency in minutes is stored. For Daily/Weekly/Monthly/Yearly types, the hour and minute of collection is stored in HH24:MI format. For On-Demand type, On-Demand is stored. |
UPLOAD_POLICY |
NUMBER |
The frequency with which the metric data is uploaded/stored. |
MGMT$TEMPLATE_METRIC_SETTINGS displays management template settings.
Table 6-41 MGMT$TEMPLATE_METRIC_SETTINGS
Column | Datatype | Description |
---|---|---|
TEMPLATE_NAME |
VARCHAR2(64) |
The name of the template. |
TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics and policies that are applicable for the target |
TEMPLATE_GUID |
RAW(16) |
The unique global identifier for the template. |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric for which the template collection is configured. |
METRIC_COLUMN |
VARCHAR2(64) |
The name of the metric column for which the template collection is configured. |
METRIC_GUID |
RAW(16) |
The unique global identifier for the metric column. |
COLLECTION_NAME |
VARCHAR2(64) |
The name of the collection. |
CATEGORY |
VARCHAR2(64) |
The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories. |
KEY_VALUE |
VARCHAR2(256) |
The key value for which the alert has been recorded. For composite keys, this is the first part of the key. |
KEY_VALUE2 |
VARCHAR2(256) |
For composite keys, this is the second part of the key for which the alert has been recorded |
KEY_VALUE3 |
VARCHAR2(256) |
For composite keys, this is the third part of the key for which the alert has been recorded |
KEY_VALUE4 |
VARCHAR2(256) |
For composite keys, this is the fourth part of the key for which the alert has been recorded |
KEY_VALUE5 |
VARCHAR2(256) |
For composite keys, this is the fifth part of the key for which the alert has been recorded |
KEY_OPERATOR |
NUMBER |
Specifies whether the key_value columns have any SQL wildcards. For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise. For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column |
PREVENT_OVERRIDE |
NUMBER(1) |
The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values. |
WARNING_OPERATOR |
NUMBER |
Defines the warning threshold condition to be applied 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression |
WARNING_THRESHOLD |
VARCHAR2(256) |
The value of the warning threshold. |
CRITICAL_OPERATOR |
NUMBER |
Defines the critical threshold condition to be applied 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression |
CRITICAL_THRESHOLD |
VARCHAR2(256) |
The value of the critical threshold. |
OCCURRENCE_COUNT |
NUMBER |
The number of times the test has to trigger to raise a violation. |
WARNING_ACTION_TYPE |
VARCHAR2(17) |
The warning corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an agent side fix-it job is configured. |
WARNING_ACTION_JOB_TYPE |
VARCHAR2(32) |
Specifies the job type of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
WARNING_ACTION_JOB_OWNER |
VARCHAR2(256) |
Specifies the job owner of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
WARNING_ACTION_JOB_NAME |
VARCHAR2(64) |
Specifies the job name of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ. |
CRITICAL_ACTION_TYPE |
VARCHAR2(17) |
The critical corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an |
CRITICAL_ACTION_JOB_TYPE |
VARCHAR2(32) |
Specifies the job type of the critical corrective action when CRITICAL_ACTION_TYPE is ÒCorrective-ActionÓ. |
CRITICAL_ACTION_JOB_OWNER |
VARCHAR2(256) |
Specifies the job owner of the critical corrective action when CRITICAL_ACTION_TYPE is ÒCorrective-ActionÓ. |
CRITICAL_ACTION_JOB_NAME |
VARCHAR2(64) |
Specifies the job name of the critical corrective action when CRITICAL_ACTION_TYPE is ÒCorrective-ActionÓ. |
MGMT$JOBS displays information about a job including the job's schedule.
Column | Datatype | Description |
---|---|---|
JOB_NAME |
VARCHAR2(64) |
The unique name for the job. |
JOB_ID |
RAW(16) |
The uniqe system identifier for the job. |
JOB_OWNER |
VARCHAR2(256) |
The owner/creator of the job. |
JOB_DESCRIPTION |
VARCHAR2(4000) |
Optional text describing the job function. |
JOB_TYPE |
VARCHAR2(32) |
The job type. For example, multi-task, SQL script or OS Command. |
TARGET_TYPE |
VARCHAR2() |
The type of target the job was submitted against. Applies to single-target jobs only. |
IS_LIBRARY |
NUMBER(1) |
Indicates whether or not the job is part of the job library. |
IS_RESTARTABLE |
NUMBER(1) |
Indicates whether the job can be restarted. Ò0Ó indicates the job is not restartable. Ò1Ó indicates the job is not restartable. By default, a job is not restartable if the original job owner is deleted and the job is transferred to another administrator. |
START_TIME |
DATE |
The scheduled start time. For daily, days of week and days of month schedules, the start_time denotes when the job should start. |
END_TIME |
DATE |
For all periodic schedules, the last date (and time) to run the job. For daily, day of week and day of month schedules, only the date portion is used. |
TIMEZONE_TYPE |
Possible values are 1 - Repository timezone 2- Target timezone 4 - Specified timezone region |
|
TIMEZONE_REGION |
VARCHAR2(64) |
The specified timezone region. |
SCHEDULE_TYPE |
Possible values are: 0 - Immediate schedule 1 - Run once at specified time 2 - Run on interval 3 - Run daily 4 - Run on specified days of the week 5 - Run on specified days of the month 6 - Run on specified days of the year |
|
INTERVAL |
NUMBER |
If schedule_type is interval (2) , this is the interval at which the job repeats, in minutes |
EXECUTION_HOURS |
NUMBER(3) |
Indicates the time of day at which the job will execute. Hours are specified using the 24-hour format (0 to 23). |
EXECUTION_MINUTES |
NUMBER(3) |
Indicates the time of day at which the job will execute. Minues are specified as a number between 0 and 59. |
MONTHS |
Integer Array |
For days-of-year job schedules, this indicates the ÒmonthÓ in the schedule. |
DAYS |
Integer Array |
For day-of-week/month or day(s) of the week job schedules, this iindicates the ÒdayÓ of the week/month. Days-of-week specified as numbers 1 (Sunday) to 7 (Saturday). Days-of-month specified as numbers 1 to 31. |
MGMT$JOB_TARGETS displays the target(s) the job was submitted against.
Column | Datatype | Description |
---|---|---|
JOB_NAME |
VARCHAR2(64) |
The unique name for the job. |
JOB_OWNER |
VARCHAR2(256) |
The owner/creator of the job. |
JOB_TYPE |
VARCHAR2(32) |
The job type. For example, multi-task, SQL script or OS Command. |
TARGET_NAME |
VARCHAR2(64) |
Name of the target the job was submitted against. |
TARGET_TYPE |
VARCHAR2() |
The type of target the job was submitted against. Applies to single-target jobs only. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
MGMT$JOB_EXECUTION_HISTORY displays a summary of job executions along with their status and targets for each execution.
Table 6-44 MGMT$JOB_EXECUTION_HISTORY
Column | Datatype | Description |
---|---|---|
JOB_NAME |
VARCHAR2(64) |
The unique name for the job. |
JOB_OWNER |
VARCHAR2(256) |
The owner/creator of the job. |
JOB_ID |
RAW(16) |
The uniqe system identifier for the job. |
JOB_TYPE |
VARCHAR2(32) |
The job type. For example, multi-task, SQL script or OS Command. |
EXECUTION_ID |
RAW(16) |
The unique execution identifier. |
SCHEDULED_TIME |
DATE |
The scheduled time of job execution. |
START_TIME |
DATE |
The actual time the job executed. |
END_TIME |
DATE |
The actual time the job terminated execution. |
STATUS |
INTEGER |
The current status of the job execution represented by integers 1 to 18: 1: Scheduled 2: Running 3: Failed Initialization 4: Failed 5: Succeeded 6: Suspended by User 7: Suspended: Agent Unreachable 8: Stopped 9: Suspended on Lock 10: Suspended on Event 11: Stop Pending 13: Suspend Pending 14: Inactive 15: Queued 16: Failed Retried 18: Skipped |
TARGET_NAME |
VARCHAR2(64) |
Name of the target the job was submitted against. |
TARGET_TYPE |
VARCHAR2() |
The type of target the job was submitted against. Applies to single-target jobs only. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
MGMT$JOB_STEP_HISTORY displays step-level details of job executions.
Table 6-45 MGMT$JOB_STEP_HISTORY
Column | Datatype | Description |
---|---|---|
JOB_NAME |
VARCHAR2(64) |
The unique name for the job. |
JOB_OWNER |
VARCHAR2(256) |
The owner/creator of the job. |
JOB_ID |
RAW(16) |
The uniqe system identifier for the job. |
JOB_TYPE |
VARCHAR2(32) |
The job type. For example, multi-task, SQL script or OS Command. |
EXECUTION_ID |
RAW(16) |
The unique execution identifier. |
STEP_NAME |
VARCHAR2(variable) |
The name of the job step. |
START_TIME |
DATE |
The start time of the job step. |
END_TIME |
DATE |
The end time of the job step. |
STATUS |
INTEGER |
The current status of the job execution represented by integers 1 to 18: 1: Scheduled 2: Running 3: Failed Initialization 4: Failed 5: Succeeded 6: Suspended by User 7: Suspended: Agent Unreachable 8: Stopped 9: Suspended on Lock 10: Suspended on Event 11: Stop Pending 13: Suspend Pending 14: Inactive 15: Queued 16: Failed Retried 18: Skipped |
TARGET_NAME |
VARCHAR2(64) |
Name of the target the job was submitted against. |
TARGET_TYPE |
VARCHAR2() |
The type of target the job was submitted against. Applies to single-target jobs only. |
TARGET_GUID |
RAW(16) |
The unique global identifier for the target. |
OUTPUT |
CLOB |
Generated job output. |
MGMT$JOB_ANNOTATIONS displays a summary of annotations for changes in job status.
Table 6-46 MGMT$JOB_ANNOTATIONS
Column | Datatype | Description |
---|---|---|
JOB_NAME |
VARCHAR2(64) |
The unique name for the job. |
JOB_OWNER |
VARCHAR2(256) |
The owner/creator of the job. |
JOB_STATUS |
NUMBER(2) |
The job status. Possible values are as follows: 1: Scheduled 2: Executing 3: Aborted 4: Failed 5: Completed 6: Suspended 7: Agent Down 8: Stopped 9: Suspended/Lock 11: Suspended/Blackout 13: Suspend Pending 15: Queued 16: Failed 17: Waiting 18: Skipped |
OCCURRENCE_TIMESTAMP |
DATE |
The time at which the state change occurred. |
ANNOTATION_MESSAGE |
VARCHAR2(4000) |
Annotation text. |
ANNOTATION_TIMESTAMP |
DATE |
The time the annotation was created. |
ANNOTATED_BY |
VARCHAR2(256) |
Enterprise Manager administrator who authored the the annotation. |
MGMT$JOB_NOTIFICATION_LOG displays details of notification deliveries for changes in job status.
Table 6-47 MGMT$JOB_NOTIFICATION_LOG
Column | Datatype | Description |
---|---|---|
JOB_NAME |
VARCHAR2(64) |
The unique name for the job. |
JOB_OWNER |
VARCHAR2(256) |
The owner/creator of the job. |
JOB_STATUS |
NUMBER(2) |
The job status. Possible values are as follows: 1: Scheduled 2: Executing 3: Aborted 4: Failed 5: Completed 6: Suspended 7: Agent Down 8: Stopped 9: Suspended/Lock 11: Suspended/Blackout 13: Suspend Pending 15: Queued 16: Failed 17: Waiting 18: Skipped |
OCCURRENCE_TIMESTAMP |
DATE |
The time at which the state change occurred. |
DELIVERY_MESSAGE |
VARCHAR2(1024) |
The message indicating the success or failure of the notification delivery. |
DELIVERY_TIMESTAMP |
DATE |
The time at which the log message was created. |
MGMT$CSM_REGION displays a list of regions and their member targets.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target from which the metrics will be collected (Webcache target). |
TARGET_TYPE |
VARCHAR2(64) |
Type defining the set of metrics that are applicable for the target. |
REGION_NAME |
VARCHAR2(128) |
A meaningful name for a logical group (region) containing one or more domains. For example, the REGION_NAME can be a country, company, or company division. |
DESCRIPTION |
VARCHAR2(256) |
A useful description of region. |
REGION_MEMBER |
VARCHAR2(256) |
A member of the region specified by REGION_NAME. REGION_MEMBER can be a domain name or an IP subnet address. |
REGION_MEMBER_TYPE |
VARCHAR2(16) |
Specifies the format type (domain name or IP subnet address) of REGION_ MEMBER. Member type can be specified using "D" for domain or "S" for subnet. For example: REGION_MEMBER=us.oracle MEMBER_ TYPE=D REGION_MEMBER=138.1 MEMBER_ TYPE=S |
List the regions with detailed information.
List the regions of which a target is a member.
List the targets that belong to a region
MGMT$CSM_WATCHLIST displays a list of URLs defined as part of a website target's watchlist. These URLs are periodically visited to monitor the website.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target from which the metrics will be collected (Webcache target). |
TARGET_TYPE |
VARCHAR2(64) |
Type defining the set of metrics that are applicable for the target. |
DISPLAY_NAME |
VARCHAR2(128) |
Display name for the URL. |
URL |
VARCHAR2(512) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
DESCRIPTION |
VARCHAR2(256) |
Text description of the URL. (Optional) |
List the URL watchlist for a given target
MGMT$CSM_METRIC_DETAILS displays detailed information on each individual HTTP request for composite targets (for example, a website target) that has one or more Web Cache targets.
Table 6-50 MGMT$CSM_METRIC_DETAILS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
Name of the target from which the metrics will be collected (Webcache target). |
TARGET_TYPE |
VARCHAR2(64) |
Type defining the set of metrics that are applicable for the target. |
COLLECTION_ TIMESTAMP |
DATE |
The date/time when the metric was collected |
METRIC_NAME |
VARCHAR2(64) |
The name of the metric that is being defined |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this URL. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
URL |
VARCHAR2(1024) |
URL filename relative to the webserver host and port. The response of this url is measured in elapsed_time. |
VISITOR_IP |
VARCHAR2(32) |
IP address of machine making requests |
VISITOR_NODE |
VARCHAR2(1024) |
Resolved machine name from which a logged request is made. |
VISITOR_DOMAIN |
VARCHAR2(1024) |
Domain of the machine making requests. |
VISITOR_SUBNET |
VARCHAR2(32) |
Domain subnet of the machine making the requests. |
Analyze HTTP request patterns over time with regards to visitor information (IP, subnet, domain, region) or URLs (most requested, least requested) for composite targets.
Analyze HTTP request response times over time with regards to visitor information (IP, subnet, domain, region) and URLs for composite targets.
MGMT$CSM_MT_METRIC_DETAILS displays detailed information on each individual HTTP request for Web Cache targets (i.e. member targets). If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-51 MGMT$CSM_MT_METRIC_DETAILS
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
Name of the Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
Type of the Web Cache target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. This entry may be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the composite target. This entry may be null if the Web Cache target is not a member of any composite targets. |
COLLECTION_ TIMESTAMP |
DATE |
The time when the target status change was last detected and logged in the Management Repository. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
URL |
VARCHAR2(1024) |
URL filename relative to the webserver host and port. |
VISITOR_IP |
VARCHAR2(32) |
IP address of machine making requests |
VISITOR_NODE |
VARCHAR2(1024) |
Resolved machine name from which a logged request is made. |
VISITOR_DOMAIN |
VARCHAR2(1024) |
Domain of the machine making requests. |
VISITOR_SUBNET |
VARCHAR2(32) |
Domain subnet of the machine making the requests. |
Analyze HTTP requests patterns over time with regards to visitor information (IP, subnet, domain, region) or URLs (most requested, least requested) for a particular Web Cache member target of a composite target, or for Web Cache targets that are not a member of any composite targets.
Analyze HTTP request response times over time with regards to visitor information (IP, subnet, domain, region) and URLs for a particular Web Cache member target of a composite target, or for Web Cache targets that are not a member of any composite targets.
MGMT$CSM_URL_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by URL in hourly time periods.
Table 6-52 MGMT$CSM_URL_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. This entry may be null if the Web Cache target is not a member of any composite targets. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the composite target. This entry may be null if the Web Cache target is not a member of any composite targets. |
URL |
VARCHAR2(1024) |
URL filename relative to the webserver host and port. |
ROLLUP_TIMESTAMP |
DATE |
Identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a composite target. (For example, what was the average response time experienced when accessing URL HTTP://my.oracle.com/home.html of the website my.oracle.com between 8 and 9 this morning).
MGMT$CSM_URL_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by URL in daily time periods.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM. |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a composite target. (For example, what was the avg response time experienced when accessing URL HTTP://my.oracle.com/home.html of the website my.oracle.com last Monday).
MGMT$CSM_URL_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a URL of a composite target. The data is aggregated in hourly time periods.
Table 6-54 MGMT$CSM_URL_DIST_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a URL of a composite target during a specific hour of the day (For example, compare the percentage of requests which response time was longer than 5 seconds at 8am and at 5pm).
MGMT$CSM_URL_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a URL of a composite target. The data is aggregated in daily time periods.
Table 6-55 MGMT$CSM_URL_DIST_DAILY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a given URL of a composite target during a specific day (For example, compare the percentage of requests which response time was longer than 5 seconds on Monday and on Saturday).
MGMT$CSM_MT_URL_HOURLY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by URL in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-56 MGMT$CSM_MT_URL_HOURLY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite target. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a Web Cache target and optionally of a composite target (For example, what was the avg response time experienced when accessing URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com between 8 and 9 this morning).
MGMT$CSM_MT_URL_DAILY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by URL in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-57 MGMT$CSM_MT_URL_DAILY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a Web Cache target and optionally of a composite target. target (For example, what was the avg response time experienced when accessing URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com last Monday).
MGMT$CSM_MT_URL_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a URL of a given Web Cache target of a composite target. The data is aggregated in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-58 MGMT$CSM_MT_URL_DIST_HOURLY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a URL of a Web Cache target of a composite target during a specific hour of the day (For example, how many requests for URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).
MGMT$CSM_MT_URL_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a URL of a given Web Cache target of a composite target. The data is aggregated in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-59 MGMT$CSM_MT_URL_DIST_DAILY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
URL |
VARCHAR2(1024) |
Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html"). |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a URL of a Web Cache target of a composite target during a specific day (For example, how many requests for URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds last Monday).
MGMT$CSM_IP_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by the visitor IP address in hourly time periods.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing the website my.oracle.com between 8 and 9 this morning).
MGMT$CSM_IP_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by visitor IP address in daily time periods.
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing the website my.oracle.com last Monday).
MGMT$CSM_IP_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a composite target. The data is aggregated in hourly time periods.
Table 6-62 MGMT$CSM_IP_DIST_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
NUMBER |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a visitor IP address of a composite target during a specific hour of the day (For example, how many requests from IP address 192.168.1.1 to the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).
MGMT$CSM_IP_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a composite target. The data is aggregated in daily time periods.
Table 6-63 MGMT$CSM_IP_DIST_DAILY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
NUMBER |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a given visitor IP address of a composite target during a specific day (For example, how many requests from IP address 192.168.1.1 to the website my.oracle.com took longer than 5 seconds last Monday).
MGMT$CSM_MT_IP_HOURLY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by visitor IP address in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-64 MGMT$CSM_MT_IP_HOURLY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a Web Cache target and optionally of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing Web Cache WEB5 of the website my.oracle.com between 8 and 9 this morning).
MGMT$CSM_MT_IP_DAILY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by visitor IP address in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-65 MGMT$CSM_MT_IP_DAILY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a Web Cache target and optionally of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing Web Cache WEB5 of the website my.oracle.com last Monday).
MGMT$CSM_MT_IP_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a given Web Cache target of a composite target. The data is aggregated in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-66 MGMT$CSM_MT_IP_DIST_HOURLY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a visitor IP address of a Web Cache target of a composite target during a specific hour of the day (For example, how many requests from IP address 192.168.1.1 to Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).
MGMT$CSM_MT_IP_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a given Web Cache target of a composite target. The data is aggregated in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.
Table 6-67 MGMT$CSM_MT_IP_DIST_DAILY
Column | Datatype | Description |
---|---|---|
MEMBER_TARGET_ NAME |
VARCHAR2(64) |
The Web Cache target. |
MEMBER_TARGET_TYPE |
VARCHAR2(64) |
The target type defines the set of metrics that are applicable for the target. |
COMPOSITE_TARGET_ NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets. |
COMPOSITE_TARGET_ TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets. |
VISITOR |
VARCHAR2(1024) |
Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a visitor IP address of a Web Cache target of a composite target during a specific day (For example, how many requests from IP address 192.168.1.1 to Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds last Monday).
MGMT$CSM_DOMAIN_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by the visitor IP domain in hourly time periods.
Table 6-68 MGMT$CSM_DOMAIN_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_DOMAIN |
VARCHAR2(1024) |
Domain of the machine making requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP domain of a composite target (For example, what was the avg response time experienced from users of the domain oracle.co.uk when accessing the website my.oracle.com between 8 and 9 this morning).
MGMT$CSM_DOMAIN_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by visitor IP domain in daily time periods.
Table 6-69 MGMT$CSM_DOMAIN_DAILY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_DOMAIN |
VARCHAR2(1024) |
Domain of the machine making requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP domain of a composite target (For example, what was the avg response time experienced from users of the domain oracle.co.uk when accessing the website my.oracle.com last Monday).
MGMT$CSM_DOMAIN_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP domain of a composite target. The data is aggregated in hourly time periods.
Table 6-70 MGMT$CSM_DOMAIN_DIST_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_DOMAIN |
VARCHAR2(1024) |
Domain of the machine making requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a visitor IP domain of a composite target during a specific hour of the day (For example, how many requests from users of the domain oracle.co.uk to the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).
MGMT$CSM_DOMAIN_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP domain of a composite target. The data is aggregated in daily time periods.
Table 6-71 MGMT$CSM_DOMAIN_DIST_DAILY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_DOMAIN |
VARCHAR2(1024) |
Domain of the machine making requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a given visitor IP domain of a composite target during a specific day (For example, how many requests from users of the domain oracle.co.uk to the website my.oracle.com took longer than 5 seconds last Monday).
MGMT$CSM_SUBNET_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by the visitor IP subnet in hourly time periods.
Table 6-72 MGMT$CSM_SUBNET_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_SUBNET |
VARCHAR2(32) |
Domain subnet of the machine making the requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP subnet of a composite target (For example, what was the avg response time experienced from users of the subnet 192.168.1 when accessing the website my.oracle.com between 8 and 9 this morning).
MGMT$CSM_SUBNET_DAILYdisplays statistical information about the HTTP requests for a given composite target, aggregated by visitor IP subnet in daily time periods.
Table 6-73 MGMT$CSM_SUBNET_DAILY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_SUBNET |
VARCHAR2(32) |
Domain subnet of the machine making the requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
AVERAGE |
NUMBER |
The average of the metric values for the samples that have been included in the rollup period |
MINIMUM |
NUMBER |
The minimum value for the metric for the samples that have been included in the rollup period. |
MAXIMUM |
NUMBER |
The maximum value for the metric for samples that have been included in the rollup period. |
STANDARD_DEVIATION |
NUMBER |
The standard deviation for the metric values that have been included in the rollup period. |
VARIANCE |
NUMBER |
The variance for the metric values that has been included in the rollup period |
Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP subnet of a composite target (For example, what was the avg response time experienced from users of the subnet 192.168.1 when accessing the website my.oracle.com last Monday).
MGMT$CSM_SUBNET_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP subnet of a composite target. The data is aggregated in hourly time periods.
Table 6-74 MGMT$CSM_SUBNET_DIST_HOURLY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_SUBNET |
VARCHAR2(32) |
Domain subnet of the machine making the requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a visitor IP subnet of a composite target during a specific hour of the day (For example, how many requests from users of the subnet 192.168.1 to the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).
MGMT$CSM_SUBNET_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP subnet of a composite target. The data is aggregated in daily time periods.
Table 6-75 MGMT$CSM_SUBNET_DIST_DAILY
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(64) |
The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. |
TARGET_TYPE |
VARCHAR2(64) |
The type of the composite target. The type defines the set of metrics that are applicable for the target. |
VISITOR_SUBNET |
VARCHAR2(32) |
Domain subnet of the machine making the requests. |
ROLLUP_TIMESTAMP |
DATE |
Start of the rollup period (time zone of the target). |
METRIC_NAME |
VARCHAR2(64) |
Name of the metric being defined. |
METRIC_VALUE |
NUMBER |
Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP |
SAMPLE_COUNT |
NUMBER |
The number of non-NULL samples for the metric that were aggregated. |
Analyze the distribution of the HTTP response times for a given visitor IP subnet of a composite target during a specific day (For example, how many requests from users of the subnet 192.168.1 to the website my.oracle.com took longer than 5 seconds last Monday).
MGMT$E2E_1DAY displays the E2E data where rollup time spans from 7 days to 31 days.
Column | Datatype | Description |
---|---|---|
URI |
VARCHAR2(2000) |
URL for which the end to end trace is sampled |
HITS |
NUMBER(8) |
No of times the uri is hit for before aggregating the sampled data. |
TOTAL_HIT_TIME |
NUMBER(10) |
Total time taken for the uri to respond. |
SERVLET_COUNT |
NUMBER(8) |
No of servlets used for serving the uri |
SERVLET_TIME |
NUMBER(10) |
Total time taken by all servlets for serving the uri. |
JSP_COUNT |
NUMBER(8) |
No of jsps used for sering the uri. |
JSP_TIME |
NUMBER(10) |
Total time taken by all jsps involved in serving the uri. |
EJB_COUNT |
NUMBER(8) |
No of EJB objects involved in serving the uri. |
EJB_TIME |
NUMBER(10) |
Total time taken by the all the EJB objects involved in the serving the uri. |
JDBC_TIME |
NUMBER(10) |
Total JDBC including SQL, PL/SQL times for serving the uri. |
TARGET_GUID |
RAW(16) |
Target GUID of the web application |
ROLLUP_TIMESTAMP |
DATE |
Since each record in the base table, mgmt_e2e_summary_1day, of this view is a rollup of daily data from mgmt_e2e_summary_1hour, this date corresponds to the time when that rollup has happened. |
MGMT$E2E_HOURLY displays E2E data where rollup time spans from 24 hours to last 7 days.
Column | Datatype | Description |
---|---|---|
URI |
VARCHAR2(2000) |
URL for which the end to end trace is sampled |
HITS |
NUMBER(8) |
No of times the uri is hit for before aggregating the sampled data. |
TOTAL_HIT_TIME |
NUMBER(10) |
Total time taken for the uri to respond. |
SERVLET_COUNT |
NUMBER(8) |
No of servlets used for serving the uri |
SERVLET_TIME |
NUMBER(10) |
Total time taken by all servlets for serving the uri. |
JSP_COUNT |
NUMBER(8) |
No of jsps used for sering the uri. |
JSP_TIME |
NUMBER(10) |
Total time taken by all jsps involved in serving the uri. |
EJB_COUNT |
NUMBER(8) |
No of EJB objects involved in serving the uri. |
EJB_TIME |
NUMBER(10) |
Total time taken by the all the EJB objects involved in the serving the uri. |
JDBC_TIME |
NUMBER(10) |
Total JDBC including SQL, PL/SQL times for serving the uri. |
TARGET_GUID |
RAW(16) |
Target GUID of the web application |
ROLLUP_TIMESTAMP |
DATE |
Since each record in the base table, mgmt_e2e_summary_1day, of this view is a rollup of daily data from mgmt_e2e_summary_1hour, this date corresponds to the time when that rollup has happened. |
MGMT$E2E_RAW displays E2E data where rollup time is less than 24 hours.
Column | Datatype | Description |
---|---|---|
URI |
VARCHAR2(2000) |
URL for which the end to end trace is sampled |
HITS |
NUMBER(8) |
No of times the uri is hit for before aggregating the sampled data. |
TOTAL_HIT_TIME |
NUMBER(10) |
Total time taken for the uri to respond. |
SERVLET_COUNT |
NUMBER(8) |
No of servlets used for serving the uri |
SERVLET_TIME |
NUMBER(10) |
Total time taken by all servlets for serving the uri. |
JSP_COUNT |
NUMBER(8) |
No of jsps used for sering the uri. |
JSP_TIME |
NUMBER(10) |
Total time taken by all jsps involved in serving the uri. |
EJB_COUNT |
NUMBER(8) |
No of EJB objects involved in serving the uri. |
EJB_TIME |
NUMBER(10) |
Total time taken by the all the EJB objects involved in the serving the uri. |
JDBC_TIME |
NUMBER(10) |
Total JDBC including SQL, PL/SQL times for serving the uri. |
TARGET_GUID |
RAW(16) |
Target GUID of the web application |
ROLLUP_TIMESTAMP |
DATE |
Since each record in the base table, mgmt_e2e_summary_1day, of this view is a rollup of daily data from mgmt_e2e_summary_1hour, this date corresponds to the time when that rollup has happened. |
MGMT$DB_TABLESPACES displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables..
Table 6-79 MGMT$DB_TABLESPACES
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the datafiles. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace. |
CONTENTS |
VARCHAR2(9) |
Tablespace contents: PERMANENT or TEMPORARY. |
STATUS |
VARCHAR2(10), |
Tablespace status: ONLINE, OFFLINE, or READ ONLY. |
EXTENT_MANAGEMENT |
VARCHAR2(10), |
Extent management tracking: DICTIONARY or LOCAL. |
ALLOCATION_TYPE |
VARCHAR2(10), |
Type of extent allocation in effect for this tablespace. |
LOGGING |
VARCHAR2(10), |
Default logging attribute. |
TABLESPACE_SIZE |
NUMBER |
Current size of the tablespace in bytes. |
INITIAL_EXT_SIZE |
NUMBER |
Default initial extent size |
NEXT_EXTENT |
NUMBER |
Next extent in the sequence. |
INCREMENT_BY |
NUMBER |
Default percent increase for extent size. |
MAX_EXTENTS |
NUMBER |
Default maximum number of extents |
TABLESPACE_USED_SIZE |
NUMBER |
Amount of data (in bytes) contained in the tablespace. |
SEGMENT_SPACE_MANAGEMENT |
VARCHAR2(6) |
Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO) |
BLOCK_SIZE |
NUMBER |
Tablespace block size |
MIN_EXTENTS |
NUMBER |
Default minimum number of extents |
MIN_EXTLEN |
NUMBER |
Minimum extent size for this tablespace |
BIGFILE |
VARCHAR2(3) |
Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO) |
Obtain control file configuration settings across all managed database targets.
MGMT$DB_DATAFILES displays the configuration settings for datafiles. The datafile settings are collected from sources such as sys.dba_data_files, v$datafile, sys.dba_free_space, sys.dba_tablespaces, sys.dba_ temp_files, v$tempfile.
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the datafiles. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
FILE_NAME |
VARCHAR2(512) |
Name of the datafile. |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace containing |
STATUS |
VARCHAR2(10) |
Datafile status: ACTIVE or NOT ACTIVE |
FILE_SIZE |
NUMBER |
Size of the datafile |
AUTOEXTENSIBLE |
VARCHAR2(3) |
Autoextensible indicator |
INCREMENT_BY |
NUMBER |
Autoextension increment. |
MAX_FILE_SIZE |
NUMBER |
Maximum file size in bytes |
OS_STORAGE_ENTITY |
VARCHAR2(512) |
OS level storage entity on which the file resides. For regular files it is the name of the filesystem on which the file resides. For character or raw files it is the name of the raw device |
MGMT$DB_CONTROLFILES displays the configuration settings for database control files.
Table 6-81 MGMT$DB_CONTROLFILES
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the datafiles. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
FILE_NAME |
VARCHAR2(512) |
Name of the database control file. |
STATUS |
VARCHAR2(10), |
The type of control file: STANDBY - indicates database is in standby mode LOGICAL - indicates the database is a logical standby database (not a physical standby) CLONE - indicates a clone database BACKUP | CREATED - indicates database is being recovered using a backup or created control file. CURRENT - the control file changes to this type following a standby database activate or database open after recovery. |
CREATION_DATE |
DATE |
Control file creation date. |
SEQUENCE_NUM |
NUMBER |
Control file sequence number incremented by control file transactions. |
CHANGE_NUM |
NUMBER |
Last change number in the backup control file. Value is NULL if the control file is not a backup. |
MOD_DATE |
DATE |
Last timestamp in the backup control file. NULL if the control file is not a backup. |
OS_STORAGE_ENTITY |
VARCHAR2(512) |
OS level storage entity on which the file resides. For regular files it is the name of the filesystem on which the file resides. For character or raw files it is the name of the raw device |
MGMT$DB_DBNINSTANCEINFO displays general information about database instance. The instance information is collected from v$database, v$version, v$instance, global_name, database_properties and v$nls_parameters.
Table 6-82 MGMT$DB_DBNINSTANCEINFO
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
Name of the target host where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database target from which the metrics are collected. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
DATABASE_NAME |
VARCHAR2(9) |
Name of the database. |
GLOBAL_NAME |
VARCHAR2(4000) |
Global name of the database |
BANNER |
VARCHAR2(64) |
Component name and version number |
HOST |
VARCHAR2(64) |
Name of the host machine. |
INSTANCE_NAME |
VARCHAR2(16) |
Name of the instance. |
STARTUP_TIME |
DATE |
Time when instance was started up. |
LOGINS |
VARCHAR2(10) |
ALLOWED or RESTRICTED |
LOG_MODE |
VARCHAR2(12) |
The archive log mode, either ARCHIVELOG or NOARCHIVELOG. |
OPEN_MODE |
VARCHAR2(10) |
Open mode information. |
DEFAULT_TEMP_TABLESPACE |
VARCHAR2(30) |
Default temporary tablespace name. |
CHARACTERSET |
VARCHAR2(64) |
NLS parameter value for NLS_CHARACTERSET |
NATIONAL_CHARACTERSET |
VARCHAR2(64) |
NLS parameter value for NLS_NCHAR_CHARACTERSET |
Obtain general instance information across all database targets.
MGMT$DB_FEATUREUSAGE displays information about database feature usage.
Table 6-83 MGMT$DB_FEATUREUSAGE
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Name of the host target where the database feature usage information is collected. |
DATABASE_NAME |
VARCHAR2(256) |
Name of the database where the database feature usage information is collected. |
INSTANCE_NAME |
VARCHAR2(16) |
Name of the instance where the database feature usage information is collected. |
TARGET_TYPE |
VARCHAR2(64) |
Either Oracle_database or rac_database. |
DBID |
NUMBER |
A unique number that identifies a database instance. |
NAME |
VARCHAR2(64) |
The feature name. |
CURRENTLY_USED |
VARCHAR2(5) |
TRUE if the feature is currently in use, FALSE if the feature is not in use. |
DETECTED_USAGES |
NUMBER |
The number of times the feature has been used by the database. |
FIRST_USAGE_DATE |
DATE |
The date that the first usage of the feature occurred. |
LAST_USAGE_DATE |
DATE |
The date of the most recent usage of the feature. |
VERSION |
VARCHAR2(17) |
The version number of the database. |
LAST_SAMPLE_DATE |
DATE |
The date that the database was last evaluated for feature usage. |
LAST_SAMPLE_PERIOD |
NUMBER |
The interval between the LAST_ SAMPLE_DATE date and the database feature usage evaluation before that (by default, seven days). |
SAMPLE_INTERVAL |
NUMBER |
The number of seconds between the LAST_SAMPLE_DATE date and the next database feature usage evaluation. |
TOTAL_SAMPLES |
NUMBER |
The total number of database feature usage evaluation samples that have been collected. |
AUX_COUNT |
NUMBER |
For Oracle internal use only. |
DESCRIPTION |
VARCHAR2(128) |
The description of the feature. |
This view can be used to gain an enterprise-wide view of database feature usage across all Oracle databases.
MGMT$DB_INIT_PARAMS displays initialization parameter settings for the database. Initialization parameter settings are collected from v$parameter.
Table 6-84 MGMT$DB_INIT_PARAMS
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database target from which the metrics are collected. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
NAME |
VARCHAR2(64) |
Name of the initialization parameter. |
ISDEFAULT |
VARCHAR2(6) |
Indicates whether the parameter value is the default. |
VALUE |
VARCHAR2(512) |
The parameter value. |
DATATYPE |
VARCHAR2 |
The data type that the value string can be mapped to, for example, NUMBER, DATE, or TEXT.' |
Obtain initialization parameter settings across all database targets.
MGMT$DB_LICENSE displays database license configuration settings. Database license configuration settings are collected from v$license.
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
The name of the host on which the database is running. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the tablespace. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
SESSIONS_MAX |
NUMBER |
The maximum number of sessions allowed for the database. |
SESSIONS_WARNING |
NUMBER |
The number of sessions which will generate a warning for the database. |
SESSIONS_CURRENT |
NUMBER |
The current number of sessions for the database. |
SESSIONS_HIGHWATER |
NUMBER |
The highest water mark of sessions for the database. |
USERS_MAX |
NUMBER |
The maximum number of users for the database. |
This view can be used to obtain database license configuration settings across all database targets.
MGMT$DB_REDOLOGS displays redo log configuration settings for the database. Redo log configuration settings are collected from the v$log and v$logfile tables.
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database target from which the metrics are collected. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
GROUP_NUM |
NUMBER |
Redo log group identifier number. |
STATUS |
VARCHAR2(16), |
og status: UNUSED - The online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log. CURRENT - This is the current redo log. This implies that the redo log is active. The redo log could be open or closed. ACTIVE - The log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be archived. CLEARING - The log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED. CLEARING_CURRENT - The current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header. INACTIVE - The log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived. |
MEMBERS |
NUMBER |
Number of members in the log group |
FILE_NAME |
VARCHAR2(513), |
Redo log file (member) name. |
ARCHIVED |
VARCHAR2(3), |
Archive status either YES or NO. |
LOGSIZE |
NUMBER |
Size of the log file in bytes |
SEQUENCE_NUM |
NUMBER |
Log sequence number |
FIRST_CHANGE_SCN |
NUMBER |
Lowest SCN in the log. |
OS_STORAGE_ENTITY |
VARCHAR2(512) |
OS level storage entity on which the file resides. For regular files it is the name of the filesystem on which the file resides. For character or raw files it is the name of the raw device. |
THREAD_NUM |
NUMBER |
Log thread number. |
Obtain redo log group / file configuration settings across all database targets.
MGMT$DB_ROLLBACK_SEGS displays rollback segments configuration settings for the database. Rollback segments configuration settings are collected from the sys.dba_rollback_segs and v$rollstat tables.
Table 6-87 MGMT$DB_ROLLBACK_SEGS
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2 |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the datafiles. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
ROLLNAME |
VARCHAR2(64)) |
Name of the rollback segment |
STATUS |
VARCHAR2(10) |
Rollback segment status |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace containing the rollback segment. |
EXTENTS |
NUMBER |
Number of extents in rollback segment. |
ROLLSIZE |
NUMBER |
Size in bytes of rollback segment. This values differs by the number of bytes in one database block from the value of the BYTES column of the ALL/DBA/USER_ SEGMENTS views. |
INITIAL_SIZE |
NUMBER |
Initial extent size in bytes. |
NEXT_SIZE |
NUMBER |
Secondary extent size in bytes. |
MAXIMUM_EXTENTS |
NUMBER |
Maximum number of extents. |
MINIMUM_EXTENTS |
NUMBER |
Minimum number of extents. |
PCT_INCREASE |
NUMBER |
Percent increase for extent size. |
OPTSIZE |
NUMBER |
Optimal size for rollback segments. |
AVEACTIVE |
NUMBER |
Current size of active extents averaged over time. |
WRAPS |
NUMBER |
Number of times rollback segment is wrapped. |
SHRINKS |
NUMBER |
Number of times the size of a rollback segment decreases. |
AVESHRINK |
NUMBER |
Average shrink size. |
HWMSIZE |
NUMBER |
High water mark of rollback segment size. |
Obtain rollback segments configuration settings across all database targets.
MGMT$DB_SGA displays System Global Area (SGA) configuration settings. SGA settings are collected from the v$sga and v$sgastat tables.
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the datafiles. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
SGANAME |
VARCHAR2(64) |
SGA component name. |
SGASIZE |
NUMBER |
SGA component size in kilobytes or megabytes |
Obtain System Global Area configuration settings across all database targets.
MGMT$DB_TABLESPACES displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables.
Table 6-89 MGMT$DB_TABLESPACES
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace. |
CONTENTS |
VARCHAR2(9) |
Tablespace contents: PERMANENT or TEMPORARY. |
STATUS |
VARCHAR2(10), |
Tablespace status: ONLINE, OFFLINE, or READ ONLY. |
EXTENT_MANAGEMENT |
VARCHAR2(10), |
Extent management tracking: DICTIONARY or LOCAL. |
ALLOCATION_TYPE |
VARCHAR2(10), |
Type of extent allocation in effect for this tablespace. |
LOGGING |
VARCHAR2(10), |
Default logging attribute. |
TABLESPACE_SIZE |
NUMBER |
Current size of the tablespace in bytes. |
INITIAL_EXT_SIZE |
NUMBER |
Default initial extent size |
INCREMENT_BY |
NUMBER |
Default percent increase for extent size. |
MAX_EXTENTS |
NUMBER |
Default maximum number of extents |
Obtain tablespace configuration settings across all database targets.
MGMT$DB_OPTIONS displays whether or not the option is currently LOADED and ACTIVE, or either the option does not exist or is NOT LOADED or INACTIVE. Options settings are collected by checking user name and status in the sys.dba_users and dba_registry tables.
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Name of the target where the metrics will be collected. |
TARGET_NAME |
VARCHAR2(256) |
Name of the database containing the datafiles. |
TARGET_TYPE |
VARCHAR2(64) |
The type of target, for example, Oracle_ database. |
TARGET_GUID |
RAW(16) |
The unique ID for the database target. |
COLLECTION_ TIMESTAMP |
DATE |
The date and time when the metrics were collected. |
NAME |
VARCHAR2(30) |
Name of the database option. |
SELECTED |
VARCHAR2(5) |
If the option is currently LOADED and ACTIVE (TRUE), or either the option does not exist or is NOT LOADED or INACTIVE (FALSE) |
Obtain tablespace configuration settings across all database targets.
MGMT$EM_HOMES_PLATFORM displays the platform information about the Homes. If the home does not have an ARU platform id, then the platform of the Operating System is considered as the Platform of the home.
MGMT$HOMES_AFFECTED displays the list of homes, vulnerable to bugs, which are fixed by the critical patches released. The number of alerts which are applicable to the home are calculated.
MGMT$APPL_PATCH_AND_PATCHSET displays the list of interim patches and patchsets that are applicable to the Homes.
Table 6-93 MGMT$APPL_PATCH_AND_PATCHSET
Column | Datatype | Description |
---|---|---|
PATCH_ID |
NUMBER |
The patch Id |
TYPE |
VARCHAR2(32) |
Patch/Patchset |
PRODUCT |
VARCHAR2(50) |
The product on pertaining to the patch. |
PATCH_RELEASE |
VARCHAR2(30) |
Release version. |
PLATFORM |
VARCHAR2(40) |
Platform on which patch is applicable |
ADVISORY |
VARCHAR2(256) |
The alert name. |
HOST_NAME |
VARCHAR2(256) |
Host name |
HOME_LOCATION |
VARCHAR2(128) |
Home directory location. |
PATCH_GUID |
RAW(16) |
Unique id for the patch/patchset. |
TARGET_GUID |
RAW(16) |
Unique id for target. |
MGMT$APPLIED_PATCHES displays the list of patches that have been applied on the homes along with the installation time. Each patch can fix more than one bug. The bugs are listed in a comma-separated string.
Table 6-94 MGMT$APPLIED_PATCHES
Column | Datatype | Description |
---|---|---|
PATCH |
VARCHAR2(128) |
Patch name. |
BUGS |
VARCHAR2(256) |
The bugs fixed by this patch. |
INSTALLATION_TIME |
DATE |
Time of Installation. Timezone of the target. |
HOST |
VARCHAR2(256) |
Host name. |
HOME_LOCATION |
VARCHAR2(128) |
Home location. |
HOME_NAME |
VARCHAR2(64) |
Name of the home. |
CONTAINER_GUID |
RAW(16) |
Name of the home. |
TARGET_GUID |
RAW(16) |
Unique id for target. |
MGMT$APPLIED_PATCHSETS displays the list of patchsets that have been applied on the Homes along with the installation time.
Table 6-95 MGMT$APPLIED_PATCHSETS
Column | Datatype | Description |
---|---|---|
VERSION |
VARCHAR2(64) |
The version to which the home will get upgraded to when this patchset is applied |
NAME |
VARCHAR2(128) |
Patchset external name |
TIMESTAMP |
DATE |
Time of Installation.Timezone of the target |
HOST |
VARCHAR2(256) |
Host name. |
HOME_LOCATION |
VARCHAR2(128) |
Home location. |
HOME_NAME |
VARCHAR2(64) |
Name of the home. |
CONTAINER_GUID |
RAW(16) |
Name of the home. |
TARGET_GUID |
RAW(16) |
Unique id for target. |
MGMT$HOSTPATCH_HOSTS displays information required to generate compliance reports.
Table 6-96 MGMT$HOSTPATCH_HOSTS
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
Host name |
GROUP_NAME |
VARCHAR2(256) |
The group the host belongs to. |
OUT_OF_DATE_PACKAGES |
NUMBER(6) |
Number of Packages which have a newer version available |
ROGUE_PACKAGES |
NUMBER(6) |
The packages that are not supposed to be installed on the host |
MGMT$HOSTPATCH_GROUPS displays additional information about a group, the maturity level which is set by the administrator and the packages which need the host to be rebooted on application.
Table 6-97 MGMT$HOSTPATCH_GROUPS
Column | Datatype | Description |
---|---|---|
GROUP_NAME |
VARCHAR2(256) |
The (unique) name of the Group |
MATURITY_LEVEL |
VARCHAR2(32) |
The maturity level of the group. This is set by the administrator. |
NEED_REBOOT_PKGS |
VARCHAR2(256) |
Comma seperated list of packages which need the machine to be rebooted on application |
MGMT$HOSTPATCH_GRP_COMPL_HIST displays information required to generate compliance history reports.
MGMT$ESA_ALL_PRIVS_REPORT displays a table containing users and roles that have the 'GRANT ANY' privilege in database security reports.
Table 6-100 MGMT$ESA_ALL_PRIVS_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted a privilege which amounts to all privileges on the database. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege (GRANT ANY PRIVILEGE) if granted directly, or the role through it has been granted. |
MGMT$ESA_ANY_DICT_REPORT displays a table and a chart containing users and roles with access to any dictionary in database security reports.
Table 6-101 MGMT$ESA_ANY_DICT_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted a privilege which provides it access to any dictionary in the database. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege if granted directly, or the role through it has been granted. |
MGMT$ESA_ANY_PRIV_REPORT displays a table and a chart containing users with 'ANY' in some privilege granted to them in database security reports.
Table 6-102 MGMT$ESA_ANY_PRIV_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted a privilege having 'ANY' |
OBJECT_NAME |
VARCHAR2(512) |
The privilege if granted directly, or the role through it has been granted. |
MGMT$ESA_AUDIT_SYSTEM_REPORT displays a table containing users and roles with the 'AUDIT SYSTEM' privilege in database security reports.
Table 6-103 MGMT$ESA_AUDIT_SYSTEM_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for whichthe report has the data |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted 'AUDIT SYSTEM' privilege. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege if granted directly, or the role through it has been granted. |
MGMT$ESA_BECOME_USER_REPORT displays a table containing users and roles with the 'BECOME USER' privilege in database security reports.
Table 6-104 MGMT$ESA_BECOME_USER_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted 'BECOME USER' privilege. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege if granted directly, or the role through it has been granted. |
MGMT$ESA_CATALOG_REPORT displays a table and a chart containing all the users that have a role such as '%CATALOG%' in database security reports.
Table 6-105 MGMT$ESA_CATALOG_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted a role like '%CATALOG%' |
OBJECT_NAME |
VARCHAR2(512) |
The role if granted directly, or the role through it has been granted. |
MGMT$ESA_CONN_PRIV_REPORT displays a table and a chart containing users and roles with the CONNECT or RESOURCE role in database security reports.
Table 6-106 MGMT$ESA_CONN_PRIV_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted the CONNECT or RESOURCE role. |
OBJECT_NAME |
VARCHAR2(512) |
The role if granted directly, or the role through it has been granted. |
MGMT$ESA_CREATE_PRIV_REPORT displays a table and a chart containing users and roles with the CREATE privilege in database security reports.
Table 6-107 MGMT$ESA_CREATE_PRIV_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted the privilege to create an object in the database. |
OBJECT_NAME |
VARCHAR2(512) |
The role if granted directly, or the role through it has been granted. |
MGMT$ESA_DBA_GROUP_REPORT displays a table containing members of the operating system user group DBA in database security reports.
Table 6-108 MGMT$ESA_DBA_GROUP_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The operating system user which is in the user group DBA. |
OBJECT_NAME |
VARCHAR2(512) |
DBA Group |
MGMT$ESA_DBA_ROLE_REPORT displays a table containing users and roles with the DBA role granted to them in database security reports.
Table 6-109 MGMT$ESA_DBA_ROLE_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted the DBA Role. |
OBJECT_NAME |
VARCHAR2(512) |
The role if granted directly, or the role through it has been granted. |
MGMT$ESA_DIRECT_PRIV_REPORT displays a table and a chart containing privileges granted directly in database security reports.
Table 6-110 MGMT$ESA_DIRECT_PRIV_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
User which has been granted a privilege directly i.e. not via a role. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege that has been granted directly.. |
MGMT$ESA_EXMPT_ACCESS_REPORT displays a table containing users and roles with the EXEMPT ACCESS POLICY privilege in database security reports.
Table 6-111 MGMT$ESA_EXMPT_ACCESS_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted the 'EXEMPT ACCESS POLICY' privilege. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege if granted directly, or the role through it has been granted. |
MGMT$ESA_KEY_OBJECTS_REPORT displays a table and a chart containing users and roles with access to key objects in database security reports.
Table 6-112 MGMT$ESA_KEY_OBJECTS_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
USER |
VARCHAR2(512) |
The user which has access to key objects. |
OBJECT_NAME |
VARCHAR2(23) |
The key object to which that use has access. |
PRIVILEGE |
VARCHAR2(512) |
The privilege on the key object that has been granted to the user. |
MGMT$ESA_OH_OWNERSHIP_REPORT displays a table containing file ownership by Oracle Home in database security reports.
Table 6-113 MGMT$ESA_OH_OWNERSHIP_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The file whose owner is not the ORACLE HOME owner. |
OBJECT_NAME |
VARCHAR2(512) |
The owner of the file. |
MGMT$ESA_OH_PERMISSION_REPORT displays a table containing file permissions by Oracle Home in database security reports.
Table 6-114 MGMT$ESA_OH_PERMISSION_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The file that has an insecure permission. |
OBJECT_NAME |
VARCHAR2(512) |
The permission of the file. |
MGMT$ESA_POWER_PRIV_REPORT displays a table and a chart containing all the users and roles with ALTER SESSION, ALTER SYSTEM, CREATE PROCEDURE or CREATE LIBRARY privileges in database security reports.
Table 6-115 MGMT$ESA_POWER_PRIV_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user that has powerful privileges. |
OBJECT_NAME |
VARCHAR2(512) |
The powerful privilege held by the user. |
MGMT$ESA_PUB_PRIV_REPORT displays a table and a chart containing privileges granted to PUBLIC in database security reports.
Table 6-116 MGMT$ESA_PUB_PRIV_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The object on which some privilege has been granted to PUBLIC. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege on the object which has been granted to PUBLIC. |
MGMT$ESA_SYS_PUB_PKG_REPORT displays a table containing system packages with public execute privileges in database security reports.
Table 6-117 MGMT$ESA_SYS_PUB_PKG_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
PUBLIC |
OBJECT_NAME |
VARCHAR2(512) |
The package owned by SYS on which PUBLIC has execute privileges. |
MGMT$ESA_TABSP_OWNERS_REPORT displays a table containing tablespaces and their owners in database security reports.
Table 6-118 MGMT$ESA_TABSP_OWNERS_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The tablespace. |
OBJECT_NAME |
VARCHAR2(512) |
The owner of the tablespace. |
MGMT$ESA_TRC_AUD_PERM_REPORT displays a table containing trace and audit files permissions in database security reports.
Table 6-119 MGMT$ESA_TRC_AUD_PERM_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The file path. |
OBJECT_NAME |
VARCHAR2(512) |
The purpose of the file. |
PERMISSION |
VARCHAR2(512) |
Permission of the file. |
MGMT$ESA_WITH_ADMIN_REPORT displays a table and a chart containing users and roles having some privileges granted to them with the WITH ADMIN option in database security reports.
Table 6-120 MGMT$ESA_WITH_ADMIN_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted a privilege 'WITH ADMIN' option. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege which has been granted 'WITH ADMIN' option. |
MGMT$ESA_WITH_GRANT_REPORT displays a table and a chart containing users and roles having some privileges granted to them with 'WITH GRANT' option in database security reports.
Table 6-121 MGMT$ESA_WITH_GRANT_REPORT
Column | Datatype | Description |
---|---|---|
TARGET_GUID |
RAW(16) |
The GUID of the target for which the report has the data. |
TARGET_NAME |
VARCHAR2(256) |
The name of the target for which the report has the data. |
PRINCIPAL |
VARCHAR2(512) |
The user or role which has been granted a privilege 'WITH GRANT' option. |
OBJECT_NAME |
VARCHAR2(512) |
The privilege which has been granted 'WITH GRANT' option. |
MGMT$CSA_COLLECTIONS displays top-level information about all client configurations.
Table 6-122 MGMT$CSA_COLLECTIONS
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
CSACLIENT |
VARCHAR2(4000) |
The display name plus the custom keys, if they exist |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected from the client |
NET_IP |
VARCHAR2(20) |
The actual IP address of the client. |
NET_EFFECTIVE_IP |
VARCHAR2(20) |
The client IP address seen by the server |
COLLECTION_MESSAGE |
VARCHAR2(4000) |
Error message generated while applet was running |
OS_USER_NAME |
VARCHAR2(500) |
The client's OS username. |
HOSTNAME |
VARCHAR2(128) |
The client's hostname. |
DOMAIN |
VARCHAR2(500) |
The client's domain. |
BOOT_DISK_VOLUME_SERIAL_NUM |
VARCHAR2(629) |
The client's boot disk volume serial number |
COMPLIANCE |
NUMBER |
The overall compliance score for the client (15=passed, 18=info, 20=warning, 25=critical) |
APPID |
VARCHAR2(128) |
The collection tag for this client configuration |
NET_SUBNET |
VARCHAR2(20) |
The client's subnet mask |
NET_LATENCY_IN_MS |
NUMBER |
The client's HTTP response time with the server |
NET_BANDWIDTH_IN_KBITPS |
NUMBER |
The client's download bandwidth from the server |
BROWSER_TYPE |
VARCHAR2(100) |
The name of the browser used to run CSA |
BROWSER_VERSION |
VARCHAR2(20) |
The version of the browser used to run CSA |
BROWSER |
VARCHAR2(121) |
A summary column that combines the browser name and version |
BROWSER_JVM_VENDOR |
VARCHAR2(20) |
The version of the JVM used to run the applet |
BROWSER_JVM_VERSION |
VARCHAR2(20) |
The version of the JVM used to run the applet |
BROWSER_PROXY_SERVER |
VARCHAR2(4000) |
The proxy server used by the browser |
BROWSER_PROXY_EXCEPTIONS |
VARCHAR2(4000) |
The client's browser proxy exceptions |
BROWSER_CACHE_SIZE_IN_MB |
NUMBER |
The client browser's disk cache size |
BROWSER_CACHE_UPATE_FRQ |
VARCAHR2(200) |
The browser's cache update policy |
BROWSER_HTTP1_1_SUPPORT |
VARCHAR2(1) |
Whether or not the browser supports HTTP 1.1 |
REFERRING_URL_HEADER |
VARCHAR2(4000) |
The URL from which the user came to CSA, minus the query string |
REFERRING_URL_PARAMS |
VARCHAR2(4000) |
The query string of the URL from which the user came to CSA |
REFURL |
VARCHAR2(4000) |
The complete URL from which the user came to CSA |
CSA_URL_HEADER |
VARCHAR2(4000) |
The URL from which the user ran CSA, minus the query string |
CSA_URL_PARAMS |
VARCHAR2(4000) |
The query string of the URL from which the user ran CSA |
CSAURL |
VARCHAR2(4000) |
The complete URL from which the user ran CSA |
DESTINAION_URL_HEADER |
VARCHAR2(4000) |
The destination URL, minus the query string |
DESTINATION_URL_PARAMS |
VARCHAR2(4000) |
The query string of the destination URL |
DESTURL |
VARCHAR2(4000) |
The complete destination URL |
CONNECTION_TYPE |
NUMBER |
The estimated connection type, based on the download bandwidth (1=LAN, 2=cable, 3=dialup) |
IS_WINDOWS_ADMIN |
VARCHAR2(1) |
Whether or not the os user is a windows admin |
WINDOWS_DOMAIN |
VARCHAR2(100) |
The windows domain of the host |
BROWSER_PROXY_ENABLED |
VARCHAR2(1) |
Whether or not the proxy server is enabled in the browser |
AUTO_CONFIG_URL |
VARCHAR2(4000) |
The URL of the proxy auto-configuration script used by the browser |
NUMBER_OF_COOKIES |
NUMBER |
The number of cookies collected by CSA |
NUMBER_OF_CUSTOM_VALUES |
NUMBER |
The number of custom properties collected by CSA |
HARDWARE |
VARCHAR2(4000) |
A summary of the system configuration, machine architecture, memory, disk space, and CPU |
HARDWARE_VENDOR_NAME |
VARCHAR2(128) |
The name of the hardware vendor, e.g. ìDellî |
SYSTEM_CONFIG |
VARCHAR2(4000) |
The client's system configuration |
MACHINE_ARCHITECTURE |
VARCHAR2(500) |
The client's machine architecture |
BUS_FREQ_IN_MHZ |
NUMBER |
The frequency of the motherboard's FSB |
MEMORY_SIZE_IN_MB |
NUMBER |
The total amount of physical memory |
AVAIL_MEMORY_SIZE_IN_MB |
NUMBER |
The amount of available physical memory when CSA was run |
LOCAL_DISK_SPACE_IN_GB |
NUMBER |
The total amount of disk space |
AVAIL_LOCAL_DISK_SPACE_IN_GB |
NUMBER |
The available disk space |
CPU_COUNT |
NUMBER(8) |
The number of CPUs |
SYSTEM_SERIAL_NUMBER |
VARCAHR2(100) |
The host's serial number |
MIN_CPU_SPEED_IN_MHZ |
NUMBER |
The minimum possible CPU speed |
MAX_CPU_SPEED_IN_MHZ |
NUMBER |
The maximum possible CPU speed |
CPU |
VARCHAR2(673) |
The CPU vendor, implementation, and frequency |
CPU_BOARD_COUNT |
NUMBER(8) |
The number of CPU boards |
IOCARD_COUNT |
NUMBER(8) |
The number of IO cards |
NIC_COUNT |
NUMBER |
The number of NICs |
FAN_COUNT |
NUMBER(8) |
The number of fans |
POWER_SUPPLY_COUNT |
NUMBER(8) |
The number of power supplies |
SYSTEM_BIOS |
VARCHAR2(100) |
The system BIOS |
OPERATINGSYSTEM |
VARCHAR2(453) |
A summary of the OS name, version, update level, address length, and distributor version |
OS_NAME |
VARCHAR2(128) |
The OS name |
OS_VENDOR_NAME |
VARCHAR2(128) |
The OS vendor name |
OS_BASE_VERSION |
VARCAR2(100) |
The OS base version |
OS_UPDATE_LEVEL |
VARCHAR2(100) |
The OS update level |
OS_DISTRIBUTOR_VERSION |
VARCHAR2(100) |
The OS distributor version |
MAX_SWAP_SPACE_IN_MB |
NUMBER |
The maximum amount of swap space |
OS_ADDRESS_LENGTH_IN_BITS |
VARCHAR2(20) |
The OS address length in bits |
MAX_PROCESS_VIRTUAL_MEMORY |
NUMBER |
The maximum amount of virtual memory that can be allocated to a process |
TIMEZONE |
VARCHAR2(64) |
The time zone as reported in the registry |
TIMEZONE_REGION |
VARCHAR2(64) |
The time zone region as reported by the JVM |
TIMEZONE_DELTA |
NUMBER |
The offset in minutes from GMT |
NUMBER_OF_OS_PROPERTIES |
NUMBER |
The number of OS properties found |
NUMBER_OF_OS_PATCHES |
NUMBER |
The number of OS patches found |
NUMBER_OF_OS_FILESYSTEMS |
NUMBER |
The number of filesystems found |
NUMBER_OF_OS_REGISTERED_SW |
NUMBER |
The number of OS-registered software products found |
SNAPSHOT_ID |
RAW(16) |
The GUID of this configuration |
TARGET_ID |
RAW(16) |
The GUID of the collector target |
INTERNAL_TARGET_NAME |
VARCHAR2(264) |
The internal name of the client configuration |
INTERNAL_TARGET_TYPE |
VARCHAR2(64) |
oracle_csa_client |
COLLECTION_DURATION |
NUMBER(16) |
The amount of time it took to run CSA |
LOADED_TIMESTAMP |
DATE |
The time at which the data was loaded into the repository |
APPLET_VERSION |
VARCHAR2(20) |
The version of the applet |
TARGET_ID_METHOD |
VARCHAR2(100) |
not used |
CUSTOM_CLASS |
VARCHAR2(1000) |
The name of the custom class (if any) |
CUSTOM_CLASS_VERSION |
VARCHAR2(1000) |
not used |
KEY1 |
VARCHAR2(4000) |
Custom key 1(optional) |
KEY2 |
VARCHAR2(4000) |
Custom key 2 (optional) |
KEY3 |
VARCHAR2(4000) |
Custom key 3 (optional) |
PROXY_TARGET_NAME |
VARCHAR2(256) |
The name of the collector target |
PROXY_TARGET_DISPLAY_NAME |
VARCHAR2(256) |
The display name of the collector target |
PROXY_TARGET_ID |
RAW(16) |
The GUID of the collector target |
RULES_COUNT |
NUMBER |
The total number of rules evaluated (including rules with status of NA) |
RULES_NA_COUNT |
NUMBER |
The number of rules that were not applicable |
RULES_PASSED_COUNT |
NUMBER |
The number of rules that passed |
RULES_INFO_COUNT |
NUMBER |
The number of rules that failed with status info |
RULES_WARNING_COUNT |
NUMBER |
The number of rules that failed with status warning |
RULES_CRITICAL_COUNT |
NUMBER |
The number of rules that failed with status critical |
MGMT$CSA_FAILED displays all failed collections.
Column | Datatype | Description |
---|---|---|
ID |
RAW(16) |
The GUID of this failed collection |
TIMESTAMP |
DATE |
The time at which this failed collection occurred |
TIMEZONE_DELTA |
NUMBER |
The offset in minutes from GMT |
SAVED_TIMESTAMP |
DATE |
The time at which the data was loaded in the repository |
EFFECTIVE_IP |
VARCHAR2(20) |
The effective IP address of the client |
APPID |
VARCHAR2(128) |
The collection tag |
REFERRING_URL_HEADER |
VARCHAR2(4000) |
The URL from which the user was referred to CSA, minus the query string |
REFERRING_URL_PARAMS |
VARCHAR2(4000) |
The query string of the URL from which the user was referred to CSA |
CSA_URL_HEADER |
VARCHAR2(4000) |
The URL from which the user ran CSA, minus the query string |
CSA_URL_PARAMS |
VARCHAR2(4000) |
The query string of the URL from which the user tried to run CSA |
DESTINATION_URL_HEADER |
VARCHAR2(4000) |
The destination URL minus the query string |
DESTINATION_URL_PARAMS |
VARCHAR2(4000) |
The query string of the destination URL |
BROWSER_TYPE |
VARCHAR2(100) |
The type of browser used to run CSA |
BROWSER_VERSION |
VARCHAR2(20) |
The version of the browser used to run CSA |
BROWSER_JVM_VENDOR |
VARCHAR(100) |
The vendor of the JVM used to run CSA |
BROWSER_JVM_VERSION |
VARCHAR2(20) |
The version of the JVM used to run CSA |
OS_ARCH |
VARCHAR2(100) |
The OS architecture of the client as reported in the ìos.archî Java system property |
OS_NAME |
VARCHAR2(100) |
The OS name of the client as reported in the ìos.nameî Java system property |
HTTP_REQUEST_USER_AGENT |
VARCHAR2(100) |
The HTTP user-agent header sent by the client |
ERROR_CODE |
VARCHAR2(1) |
The error condition that caused the failed collection (0=OS not supported, 1=browser not supported, 2=applet certificate refused by user, 3=other error) |
ERROR_TEXT |
VARCHAR2(1024) |
Text that is collected along with the error code, such as a stack trace |
MGMT$CSA_HOST_OS_COMPONENTS displays all OS components find on CSA client machines.
Table 6-124 MGMT$CSA_HOST_OS_COMPONENTS
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
TYPE |
VARCHAR2(100) |
The type of the component |
NAME |
VARCHAR2(128) |
The name of the component |
VERSION |
VARCHAR2(100) |
The version of the component |
DESCRIPTION |
VARCHAR2(2000) |
The description of the component |
ISNTALLATION_DATE |
DATE |
The date the component was installed |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The target GUID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the client configuration was collected |
MGMT$CSA_HOST_SW displays all OS-registered software found on CSA hosts.
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
NAME |
VARCHAR2(128) |
The name of the software |
VENDOR_NAME |
VARCHAR2(128) |
The name of the software vendor |
VERSION |
VARCHAR2(100) |
The version of the software |
INSTALLATION_DATE |
DATE |
The date on which the software as installed |
INSTALLED_LOCATION |
VARCHAR2(1024) |
The location in which the software is installed |
DESCRIPTION |
VARCHAR2(2000) |
The description of the software |
VENDOR_SW_SPECIFIC_INFO |
VARCHAR2(4000) |
Any additional information provided by the vendor |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_COOKIES displays the cookies collected with client configurations.
Table 6-126 MGMT$CSA_HOST_COOKIES
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
NAME |
VARCHAR2(4000) |
The name of the cookie |
VALUE |
VARCHAR2(4000) |
The payload of the cookie |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_CUSTOM displays the custom properties collected with client configurations.
Table 6-127 MGMT$CSA_HOST_CUSTOM
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
TYPE |
VARCHAR2(512) |
The category of the custom property |
NAME |
VARCHAR2(512) |
The name of the custom property |
TYPE_UI |
VARCHAR2(4000) |
The display category of the custom property |
NAME_UI |
VARCHAR2(4000) |
The display name of the custom property |
VALUE |
VARCHAR2(4000) |
The value of the custom property |
DISPLAY_UI |
VARCHAR2(1) |
Should this property be displayed in the UI? Y or N |
HISTORY_TRACKING |
VARCHAR2(1) |
Not used |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_RULES displays the rules that were evaluated with each client configuration.
Table 6-128 MGMT$CSA_HOST_RULES
Column | Datatype | Description |
---|---|---|
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
NAME |
VARCHAR2(128) |
The name of the rule |
DESCRIPTION |
VARCHAR2(256) |
The description of the rule |
STATUS |
NUMBER |
The status of the rule (-2=NA, 15=passed, 18=info, 20=warning, 25=critical) |
MOREINFO |
VARCHAR2(1024) |
Any additional information for the rule |
MGMT$CSA_HOST_CPUS displays information about the CPUs of CSA hosts. CSA assumes that in a multi-CPU host, all CPUs are identical.
Table 6-129 MGMT$CSA_HOST_CPUS
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
VENDOR_NAME |
VARCHAR2(128) |
The name of the CPU vendor |
FREQ_IN_MHZ |
NUMBER |
The clock frequency of the CPU |
ECACHE_IN_MB |
NUMBER |
The size of the extended cache |
IMPL |
VARCAHR2(500) |
The CPU implementation |
REVISION |
VARCHAR2(2000) |
The CPU revision |
MASK |
VARCHAR2(500) |
The CPU mask |
NUMBER_OF_CPUS |
NUMBER |
The number of CPUs |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_IOCARDS displays all IO cards collected from client configurations.
Table 6-130 MGMT$CSA_HOST_IOCARDS
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
VENDOR_NAME |
VARCHAR2(128) |
The name of the IO card vendor |
NAME |
VARCHAR2(128) |
The name of the IO card |
FREQ_IN_MHZ |
NUMBER |
The frequency of the IO card bus |
BUS |
VARCHAR2(500) |
The bus type (PCI or AGP) |
REVISION |
VARCHAR2(2000) |
The IO card revision |
NUMBER_OF_IOCARDS |
NUMBER |
The number of cards |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_NICS displays all network interface cards collected from client configurations.
Table 6-131 MGMT$CSA_HOST_NICS
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
NAME |
VARCHAR2(128) |
The name of the NIC |
DESCRIPTION |
VARCHAR2(500) |
The description of the NIC |
FLAGS |
VARCHAR2(1024) |
Flags set on the NIC – not applicable for Windows |
MAX_TRANSFER_UNIT |
NUMBER |
The maximum transfer unit of the NIC |
INET_ADDRESS |
VARCHAR2(20) |
The IP address of the NIC |
MASK |
VARCHAR2(20) |
The subnet mask of the NIC |
BROADCAST_ADDRESS |
VARCHAR2(20) |
The broadcast address of the NIC |
MAC_ADDRESS |
VARCHAR2(20) |
The MAC address of the NIC |
HOSTNAME_ALIASES |
VARCHAR2(4000) |
Any aliases for the hostname that are stored in the NIC |
DEFAULT_GATEWAY |
VARCHAR2(20) |
The default gateway for the NIC |
DHCP_ENABLED |
VARCHAR2(1) |
Whether or not DHCP is enabled |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_OS_PROPERTIES displays all OS properties, such as environment variables, found on CSA hosts.
Table 6-132 MGMT$CSA_HOST_OS_PROPERTIES
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
SOURCE |
VARHCAR2(128) |
The source (e.g. the system environment) of the property |
NAME |
VARCHAR2(128) |
The name of the property |
VALUE |
VARCHAR2(2000) |
The value of the property |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$CSA_HOST_OS_FILESYSEMS displays all filesystems found on CSA hosts.
Table 6-133 MGMT$CSA_HOST_OS_FILESYSEMS
Column | Datatype | Description |
---|---|---|
DISPLAY_TARGET_NAME |
VARCHAR2(256) |
The display name of the client |
RESOURCE_NAME |
VARCHAR2(128) |
The name of the filesystem |
MOUNT_LOCATION |
VARCHAR2(1024) |
The location from which it is mounted |
TYPE |
VARCHAR2(100) |
The filesystem type |
DISK_SPACE_IN_GB |
NUMBER |
The total disk space |
AVAIL_DISK_SPACE_IN_GB |
NUMBER |
The available disk space |
LOCAL_DRIVE |
VARCHAR2(1) |
The Windows drive letter on which it is mounted |
MOUNT_OPTIONS |
VARCHAR2(1024) |
The mount options |
SNAPSHOT_ID |
RAW(16) |
The snapshot ID of the client configuration |
TARGET_ID |
RAW(16) |
The ID of the collector target |
COLLECTION_TIMESTAMP |
DATE |
The time at which the data was collected |
MGMT$ECM_CONFIG_HISTORY displays the data needed for generic categories.
Table 6-134 MGMT$ECM_CONFIG_HISTORY
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
ROWGUID |
RAW(16) |
The entry ID GUID |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$ECM_CONFIG_HISTORY_KEY1 displays the data needed for specific categories.
Table 6-135 MGMT$ECM_CONFIG_HISTORY_KEY1
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
KEY1 |
VARCHAR2(4000) |
Value of Key 1 |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$ECM_CONFIG_HISTORY_KEY2 displays the data needed for specific categories.
Table 6-136 MGMT$ECM_CONFIG_HISTORY_KEY2
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
KEY1 |
VARCHAR2(4000) |
Value of Key 1 |
KEY2 |
VARCHAR2(4000) |
Value of Key 2 |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$ECM_CONFIG_HISTORY_KEY3 displays the data needed for specific categories.
Table 6-137 MGMT$ECM_CONFIG_HISTORY_KEY3
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
KEY1 |
VARCHAR2(4000) |
Value of Key 1 |
KEY2 |
VARCHAR2(4000) |
Value of Key 2 |
KEY3 |
VARCHAR2(4000) |
Value of Key 3 |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$ECM_CONFIG_HISTORY_KEY4 displays the data needed for specific categories.
Table 6-138 MGMT$ECM_CONFIG_HISTORY_KEY4
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
KEY1 |
VARCHAR2(4000) |
Value of Key 1 |
KEY2 |
VARCHAR2(4000) |
Value of Key 2 |
KEY3 |
VARCHAR2(4000) |
Value of Key 3 |
KEY4 |
VARCHAR2(4000) |
Value of Key 4 |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$ECM_CONFIG_HISTORY_KEY5 displays the data needed for specific categories.
Table 6-139 MGMT$ECM_CONFIG_HISTORY_KEY5
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
KEY1 |
VARCHAR2(4000) |
Value of Key 1 |
KEY2 |
VARCHAR2(4000) |
Value of Key 2 |
KEY3 |
VARCHAR2(4000) |
Value of Key 3 |
KEY4 |
VARCHAR2(4000) |
Value of Key 4 |
KEY5 |
VARCHAR2(4000) |
Value of Key 5 |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$ECM_CONFIG_HISTORY_KEY6 displays the data needed for specific categories.
Table 6-140 MGMT$ECM_CONFIG_HISTORY_KEY6
Column | Datatype | Description |
---|---|---|
DELTATIME |
DATE |
The time at which the diff was recorded |
DELTAGUID |
RAW(16) |
The unique ID of the diff |
TIMEZONE |
VARCHAR2(64) |
The time zone of the target |
TARGET_NAME |
VARCHAR2(256) |
The name of the target |
HOSTNAME |
VARCHAR2(256) |
The name of the target's host |
TARGET_TYPE |
VARCHAR2(64) |
The type of the target |
SNAPSHOTTYPE |
VARCHAR2(64) |
The type of the snapshot in which the diff was recorded |
COLLECTIONTYPE |
VARCHAR2(64) |
The name of the table in which the diff occurred |
TABLE_PATH |
VARCHAR2(1000) |
The full path of the table |
CATEGORY |
VARCHAR2(1132) |
The fully qualified leaf category |
OPERATION |
VARCHAR2(10) |
The type of change (update, delete, insert, same) |
KEY1 |
VARCHAR2(4000) |
Value of Key 1 |
KEY2 |
VARCHAR2(4000) |
Value of Key 2 |
KEY3 |
VARCHAR2(4000) |
Value of Key 3 |
KEY4 |
VARCHAR2(4000) |
Value of Key 4 |
KEY5 |
VARCHAR2(4000) |
Value of Key 5 |
KEY6 |
VARCHAR2(4000) |
Value of Key 6 |
ATTRIBUTE |
VARCHAR2(64) |
Attribute column name |
NEWVALUE |
VARCHAR2(4000) |
New value of attribute |
OLDVALUE |
VARCHAR2(4000) |
Old value of attribute |
MGMT$HW_NIC displays performance information for host hardware network cards.
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
The host name |
NAME |
VARCHAR2(128) |
The name of the card |
INET_ADDRESS |
VARCHAR2(20) |
The IP address of the card |
MAX_TRANSFER_UNIT |
NUMBER |
The maximum transfer unit |
BROADCAST_ADDRESS |
VARCHAR2(20 |
The broadcast address of the card |
MASK |
VARCHAR2(20) |
The card's subnet mask |
FLAGS |
VARCHAR2(1024) |
The flags on the card |
MAC_ADDRESS |
VARCHAR2(20) |
The MAC address of the card |
HOST_ALIASES |
VARCHAR2(4000) |
The aliases for the hostname |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$OS_COMPONENTS displays performance information for host OS components.
Table 6-142 MGMT$OS_COMPONENTS
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
The name of the host |
NAME |
VARCHAR2(128) |
The name of the component |
TYPE |
VARCHAR2(100) |
The type of the component |
VERSION |
VARCHAR2(100) |
The version of the component |
DESCRIPTION |
VARCHAR2(2000) |
The description of the component |
INSTALLATION_DATE |
DATE |
The installation date of the component |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$OS_FS_MOUNT displays performance information for mounted filesystems.
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
The host name |
RESOURCE_NAME |
VARCHAR2(128) |
The name of the mounted resource |
TYPE |
VARCHAR2(100) |
The filesystem type |
MOUNT_LOCATION |
VARCHAR2(1024) |
The mount location |
MOUNT_OPTIONS |
VARCHAR2(1024) |
The mount options |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$OS_HW_SUMMARY displays summary information for both operating systems and hardware.
Table 6-144 MGMT$OS_HW_SUMMARY
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
The host name |
DOMAIN |
VARCHAR2(500) |
The host's domain |
OS_SUMMARY |
VARCHAR2(352) |
A summary of OS information |
SYSTEM_CONFIG |
VARCHAR2(4000) |
The system configuration |
MA |
VARCHAR2(500) |
The machine architecture |
FREQ |
NUMBER |
The CPU frequency |
MEM |
NUMBER |
The total amount of memory |
DISK |
NUMBER |
The total amount of disk space |
CPU_COUNT |
NUMBER |
The number of CPUs |
VENDOR_NAME |
VARCHAR2(128) |
The name of the system vendor |
OS_VENDOR |
VARCHAR2(128) |
The name of the OS vendor |
DISTRIBUTOR_VERSION |
VARCHAR2(100) |
The OS distributor version |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$OS_KERNEL_PARAMS displays performance information for OS kernel parameters.
Table 6-145 MGMT$OS_KERNEL_PARAMS
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
The name of the host |
SOURCE |
VARCHAR2(128) |
The source of the parameter |
NAME |
VARCHAR2(128) |
The name of the parameter |
VALUE |
VARCHAR2(2000) |
The value of the parameter |
DATATYPE |
VARCHAR2(4000) |
The data type of the parameter |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$OS_SUMMARY displays operating system summary information.
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
The name of the host |
NAME |
VARCHAR2(128) |
The name of the OS |
VENDOR_NAME |
VARCHAR2(128) |
The name of the OS vendor |
BASE_VERSION |
VARCHAR2(100) |
The base version of the OS |
UPDATE_LEVEL |
VARCHAR2(100) |
The update level of the OS |
DISTRIBUTOR_VERSION |
VARCHAR2(100) |
The distributor version of the OS |
MAX_SWAP_SPACE_IN_MB |
NUMBER |
The maximum amount of swap space |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$SOFTWARE_COMP_PATCHSET displays information on components and patchsets.
Table 6-148 MGMT$SOFTWARE_COMP_PATCHSET
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
The name of the host |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
COMPONENT_NAME |
VARCHAR2(128) |
The name of the component |
COMPONENT_BASE_VERSION |
VARCHAR2(64) |
The base version of the component |
COMPONENT_VERSION |
VARCHAR2(64) |
The current version of the component |
PATCHSET_NAME |
VARCHAR2(128) |
The name of the patchset |
PATCHSET_VERSION |
VARCHAR2(64) |
The version of the patchset |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$SOFTWARE_COMPONENT_ONEOFF displays information on oneoff patches.
Table 6-149 MGMT$SOFTWARE_COMPONENT_ONEOFF
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARCHAR2(256) |
The name of the host |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
COMPONENT_NAME |
VARCHAR2(128) |
The name of the component |
COMPONENT_EXTERNAL_NAME |
VARCHAR2(128) |
The external name of the component |
COMPONENT_BASE_VERSION |
VARCHAR2(64) |
The base version of the component |
COMPONENT_VERSION |
VARCHAR2(64) |
The current version of the component |
PATCH_ID |
VARCHAR2(128) |
The ID of the patch |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$SOFTWARE_COMPONENTS displays information on components.
Table 6-150 MGMT$SOFTWARE_COMPONENTS
Column | Datatype | Description |
---|---|---|
NAME |
VARCHAR2(128) |
The name of the component |
EXTERNAL_NAME |
VARCHAR2(128) |
The external name of the component |
BASE_VERSION |
VARCHAR2(64) |
The base version of the component |
PATCHSETS_IN_HOME |
VARCHAR2(4000) |
List of patchsets in home |
VERSION |
VARCHAR2(64) |
The version of the component |
HOST_NAME |
VARCHAR2(256) |
The name of the host |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
DESCRIPTION |
VARCHAR2(1024) |
A description of the component |
INSTALLER_VERSION |
VARCHAR2(64) |
The version of the installer |
MIN_DEINSTALLER_VERSION |
VARCHAR2(64) |
The minimum deinstaller version |
INSTALL_TIMESTAMP |
DATE |
The installation date |
IS_TOP_LEVEL |
VARCHAR2(1) |
Whether or not the component is a top-level component |
INTERIM_PATCHES_IN_HOME |
VARCHAR2(4000) |
The interim patches in the home |
BUGS_FIXED_BY_INTERM_INPATCEHS |
VARCHAR2(4000) |
A list of bugs fixed by the interim patches in the home |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$SOFTWARE_COMPONENTS displays information on components.
Table 6-151 MGMT$SOFTWARE_DEPENDENCIES
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARHCAR2(256) |
The name of the host |
REFERENCER_HOME_NAME |
VARCHAR2(64) |
The Oracle Home of the referencing component |
REFERENCER_HOME_LOCATION |
VARCHAR2(128) |
The Oracle Home path of the referencing component |
REFERENCER_NAME |
VARCHAR2(128) |
The name of the referencing component |
REFERNCER_BASE_VERSION |
VARCHAR2(64) |
The base version of the referencing component |
REFERENCED_HOME_NAME |
VARCHAR2(64) |
The Oracle Home of the referenced component |
REFERENCED_HOME_LOCATION |
VARCHAR2(128) |
The Oracle Home path of the referenced component |
REFERENCED_NAME |
VARCHAR2(128) |
The name of the referenced component |
REFERENCED_BASE_VERSION |
VARCHAR2(64) |
The base version of the referenced component |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the configuration snapshot |
MGMT$SOFTWARE_HOMES displays information about Oracle Homes.
Table 6-152 MGMT$SOFTWARE_HOMES
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARHCAR2(256) |
The name of the host |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
HOME_TYPE |
VARCHAR2(11) |
The type of the Oracle Home |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$SOFTWARE_ONEOFF_PATCHES displays information on oneoff patches applied in Oracle Homes.
Table 6-153 MGMT$SOFTWARE_ONEOFF_PATCHES
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARHCAR2(256) |
The name of the host |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
PATCH_ID |
VARCHAR2(128) |
The ID of the patch |
INSTALL_TIMESTAMP |
DATE |
The installation date |
DESCRIPTION |
VARCHAR2(1024) |
A description of the patch |
IS_ROLLBACKABLE |
VARCHAR2(1) |
Whether or not the patch can be rolled back |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the configuration snapshot |
MGMT$SOFTWARE_OTHERS displays information on other software installed on hosts.
Table 6-154 MGMT$SOFTWARE_OTHERS
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARHCAR2(256) |
The name of the host |
SOFTWARE_NAME |
VARCHAR2(128) |
The name of the software |
SOFTWARE_VENDOR |
VARCHAR2(128) |
The software vendor |
SOFTWARE_VERSION |
VARCHAR2(128) |
The software version |
INSTALLATION_DATE |
DATE |
The software installation date |
INSTALLATION_LOCATION |
VARCHAR2(1024) |
The software installation location |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the configurtion snapshot |
MGMT$SOFTWARE_PATCHES_IN_HOMES displays information on software patches in Oracle Homes.
Table 6-155 MGMT$SOFTWARE_PATCHES_IN_HOMES
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARHCAR2(256) |
The name of the host |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
PATCH_ID |
VARCHAR2(128) |
The ID of the patch |
BUGS_FIXED |
VARCHAR2(4000) |
List of bugs fixed by the patch |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$SOFTWARE_PATCHSETS displays information on patchsets installed in Oracle Homes.
Table 6-156 MGMT$SOFTWARE_PATCHSETS
Column | Datatype | Description |
---|---|---|
HOST_NAME |
VARHCAR2(256) |
The name of the host |
HOME_NAME |
VARCHAR2(64) |
The name of the Oracle Home |
HOME_LOCATION |
VARCHAR2(128) |
The path of the Oracle Home |
NAME |
VARCHAR2(128) |
The name of the patchset |
VERSION |
VARCHAR2(64) |
The version of the patchset |
DESCRIPTION |
VARCHAR2(1024) |
A description of the patchset |
INSTALLER_VERSION |
VARCHAR2(64) |
The version of the installer |
MIN_DEINSTALLER_VERSION |
VARCHAR2(64) |
The minimum deinstaller version |
INSTALL_TIMESTAMP |
DATE |
The time at which the patchset was installed |
SNAPSHOT_GUID |
RAW(16) |
The GUID of the config. snapshot |
MGMT$CLUSTER_INTERCONNECTS displays statistics of network interfaces on the hosts in clusters.
Table 6-157 MGMT$CLUSTER_INTERCONNECTS
Column | Datatype | Description |
---|---|---|
CLUSTER_NAME |
VARCHAR2(256) |
Cluster target name |
HOST_NAME |
VARCHAR2(256) |
Host target status |
IF_NAME |
VARCHAR2(256) |
Interface name |
IF_SUBNET |
VARCHAR2(16) |
Subnet of the interface |
IF_PUBLIC |
VARCHAR2(10) |
Whether the interface is public (YES) or private(NO) |
TOTRATE_5MIN |
NUMBER |
The average total transfer rate (MB/sec) on the interface in the past 5 minutes |
TOTERR_5MIN |
NUMBER |
The percentage of error packets on the interface in the past 5 minutes |
INRATE_5MIN |
NUMBER |
The average input rate (MB/sec) on the interface in the past 5 minutes |
CURR_WARNING |
NUMBER |
The number of warning alerts on the interface |
CURR_CRITICAL |
NUMBER |
The number of critial alerts on the interface. |
LATEST_COLLECTION_TIMESTAMP |
DATE |
The time when the data is collected. |
MGMT$RACDB_INTERCONNECTS displays statistics of the inter-instance traffic of cluster databases.
Table 6-158 MGMT$RACDB_INTERCONNECTS
Column | Datatype | Description |
---|---|---|
CLUSTER_NAME |
VARCHAR2(1024) |
Cluster target name |
DB_TARGET |
VARCHAR2(256) |
Cluster database target name |
INSTANCE_TARGET |
NUMBER |
Cluster database instance target name. |
INSTANCE_STATUS |
NUMBER |
Cluster database instance status |
DB_NAME |
VARCHAR2(1024) |
Database name |
SID |
VARCHAR2(1024) |
Instance name |
IF_NAME |
VARCHAR2(50) |
The network interface the instance is using for inter-instance communication |
HOST_NAME |
VARCHAR2(256) |
Host target name on which the instance is running |
IF_IP |
VARCHAR2(16) |
The ip address of the network interface |
IF_PUBLIC |
VARCHAR2(10) |
Whether the interface is public (YES) or private (NO) |
IF_SOURCE |
VARCHAR2(100) |
Where does the instance pick up the interface |
XFERRATE_5MIN |
NUMBER |
The trasfer rate of the instance to other instances |
CURR_WARNING |
NUMBER |
The number of warning alerts of the instance regarding inter_instance communication |
CURR_CRITICAL |
NUMBER |
The number of critical alerts of the instance regarding inter_instance communication |
LATEST_COLLECTION_TIMESTAMP |
DATE |
The time the data is collected |
MGMT$HA_BACKUP displays details of the latest backup of the databases.
Column | Datatype | Description |
---|---|---|
HOST |
VARCHAR2(256) |
Host the database is on |
DATABASE_NAME |
VARCHAR2(256) |
Database target name |
TARGET_TYPE |
VARCHAR2(64) |
Target type of the database. (cluster_database or oracle_database) |
DISPLAY_NAME |
VARCHAR2(256) |
Display name of the target |
TARGET_GUID |
RAW(16) |
The target GUID |
SESSION_KEY |
NUMBER |
Session identifier |
SESSION_RECID |
NUMBER |
Together, with SESSION_STAMP, used to uniquely identify job output from V$RMAN_OUTPUT |
SESSION_STAMP |
NUMBER |
Together, with SESSION_RECID, used to uniquely identify job output from V$RMAN_OUTPUT |
COMMAND_ID |
VARCHAR2(33) |
Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN |
STATUS |
VARCHAR2(23) |
One of the following values: ² RUNNING WITH WARNINGS ² RUNNING WITH ERRORS ² COMPLETED ² COMPLETED WITH WARNINGS ² COMPLETED WITH ERRORS ² FAILED |
START_TIME |
DATE |
Start time of the first BACKUP command in the job |
END_TIME |
DATE |
End time of the last BACKUP command in the job |
TIME_TAKEN_DISPLAY |
VARCHAR2(4000) |
Time taken, shown in user-displayable format <nn>h:<nn>m:<nn>s |
INPUT_TYPE |
VARCHAR2(13) |
Contains one of the following values. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list. ² DB FULL ² RECVR AREA ² DB INCR ² DATAFILE FULL ² DATAFILE INCR ² ARCHIVELOG ² CONTROLFILE ² SPFILE |
OUTPUT_DEVICE_TYPE |
VARCHAR2(17) |
Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT). |
INPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on |
OUTPUT_BYTES_PER_SEC_DISPLAY |
VARCHAR2(4000) |
Output write-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on. |
MGMT$STORAGE_REPORT_DATA displays the Storage Data metric attributes which are common across all instrumented Storage Entities.
Table 6-160 MGMT$STORAGE_REPORT_DATA
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
KEY_VALUE |
RAW(20) |
Unique Key Value for the Storage Entity |
GLOBAL_UNIQUE_ID |
RAW(20) |
A globally unique persistent identifier for a storage entity. All instances of a shared Storage Entity will have the same global_unique_identifier |
NAME |
VARCHAR2(256) |
Name of the Storage Entity |
STORAGE_LAYER |
VARCHAR2(32) |
Storage layer of the Storage Entity. Example: - OS_DISK - VOLUME_MANAGER - LOCAL_FILESYSTEM - NFS |
ENTITY_TYPE |
VARCHAR2(64) |
Indicates the type of Entity. Value is vendor specific. Example: Plex, Sub Disk, Diskgroup, Volume group, Metadevice etc. |
RAWSIZEB |
NUMBER |
Total space in bytes |
SIZEB |
NUMBER |
Size in bytes |
USEDB |
NUMBER |
Used size in bytes |
FREEB |
NUMBER |
Free size in bytes |
MGMT$STORAGE_REPORT_KEYS displays the relationship between instrumented Storage Entities.
Table 6-161 MGMT$STORAGE_REPORT_KEYS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
KEY_VALUE |
RAW(20) |
Unique KEY_VALUE for the Storage Entity |
PARENT_KEY_VALUE |
RAW(20) |
Key value for the parent Storage Entity. |
MGMT$STORAGE_REPORT_PATHS displays the OS paths for all instrumented storage Entities.
Table 6-162 MGMT$STORAGE_REPORT_PATHS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
KEY_VALUE |
RAW(20) |
Unique Key Value for the Storage Entity |
NAME |
VARCHAR2(256) |
Name of the Storage Entity |
PATH |
VARCHAR2(256) |
OS path to the Storage Entity |
FILE_TYPE |
VARCHAR2(256) |
Type of file Examples: - _BLOCKSPECIAL - _DIRECTORY - _REGULAR |
STORAGE_LAYER |
VARCHAR2(32) |
Storage layer of the Storage Entity. Examples: - OS_DISK - VOLUME_MANAGER - LOCAL_FILESYSTEM - NFS |
ENTITY_TYPE |
VARCHAR2(64) |
Indicates the type of Entity. Value is vendor specific. Examples: Plex, Sub Disk, Diskgroup, Volume group, Metadevice etc. |
MGMT$STORAGE_REPORT_ISSUES displays the consistency issues encountered when analyzing the instrumented storage metrics.
Table 6-163 MGMT$STORAGE_REPORT_ISSUES
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
TYPE |
VARCHAR2(32) |
Type of inconsistency. Value can be one of - MAPPING_ISSUE - MAPPING_WARNING |
MESSAGE_COUNT |
NUMBER |
Count of the number of messages |
MGMT$STORAGE_REPORT_DISK displays Additional Storage Data Metric Attributes for all Physical Disk Device Storage Entities.
Table 6-164 MGMT$STORAGE_REPORT_DISK
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
ENTITY_TYPE |
VARCHAR2(64) |
Indicates the type of Disk Device such as Disk or Disk Partition |
USED_PATH |
VARCHAR2(256) |
The OS path to the disk or partition. If the disk or partition is allocated, then this is the path that is in use. |
FILE_TYPE |
VARCHAR2(256) |
Type of file Examples:- _BLOCKSPECIAL- _REGULAR |
SIZEB |
NUMBER |
Size in bytes |
USEDB |
NUMBER |
Used size in bytes |
FREEB |
NUMBER |
Free size in bytes |
VENDOR |
VARCHAR2(256) |
Name of the disk vendor; detected through SCSI enquiry |
PRODUCT |
VARCHAR2(256) |
Product family from the vendor; detected through SCSI enquiry |
MGMT$STORAGE_REPORT_VOLUME displays Additional Storage Data Metric attributes for all Volume Manager Storage Entities.
Table 6-165 MGMT$STORAGE_REPORT_VOLUME
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
VENDOR |
VARCHAR2(256) |
Vendor name of the Volume or Software Raid Manager |
PRODUCT |
VARCHAR2(256) |
Vendor name of the Volume or Software Raid Manager |
TYPE |
VARCHAR2(64) |
ndicates the type of Volume entity. It can be vendor specific. In the case of Veritas Volume Manager for e.g. Volume, Plex, VM Disk, Diskgroup, Sub Disk, Metadevice, Metadevice Partition, Array, Raiddevice, Submirror, Diskset, Slice, raid-disk, spare-disk, Hot spare etc. |
DISK_GROUP |
VARCHAR2(256) |
Disk group or Volume group name |
NAME |
VARCHAR2(256) |
The name of the entity in the volume manager namespace |
USED_PATH |
VARCHAR2(256) |
The OS path to the device. If the device is allocated, then this is the path that is in use. |
FILE_TYPE |
VARCHAR2(256) |
Type of file Examples:- _BLOCKSPECIAL- _REGULAR |
RAWSIZEB |
NUMBER |
In bytes. For a 2-way mirrored Veritas Volume. It is the sum of the size of each plex. |
SIZEB |
NUMBER |
Size in bytes |
USEDB |
NUMBER |
Used size in bytes |
FREEB |
NUMBER |
Free size in bytes |
CONFIGURATION |
VARCHAR2(256) |
A string describing the configuration of the Volume. |
MGMT$STORAGE_REPORT_LOCALFS displays Additional Storage Data Metric attributes for all Local Filesystem Storage Entities.
Table 6-166 MGMT$STORAGE_REPORT_LOCALFS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
FILESYSTEM_TYPE |
VARCHAR2(256) |
The type of filesystem |
FILESYSTEM |
VARCHAR2(256) |
The filesystem path on the operating system |
MOUNTPOINT |
VARCHAR2(256) |
The mountpoint path on the operating system |
SIZEB |
NUMBER |
NUMBER |
USEDB |
NUMBER |
Used size in bytes |
FREEB |
NUMBER |
Free size in bytes |
MGMT$STORAGE_REPORT_NFS displays Additional Storage Data Metric attributes for all Network Filesystems.
Table 6-167 MGMT$STORAGE_REPORT_NFS
Column | Datatype | Description |
---|---|---|
TARGET_NAME |
VARCHAR2(256) |
Target Name in Enterprise Manager |
TARGET_TYPE |
VARCHAR2(64) |
Target Type in Enterprise Manager |
FILESYSTEM |
VARCHAR2(256) |
The filesystem name as seen on the operating system. For NFS filesystems the filesystem name should be in the format nfs_server:/filesystem_name |
MOUNTPOINT |
VARCHAR2(256) |
The mountpoint path on the operating system |
SIZEB |
NUMBER |
Size in bytes |
USEDB |
NUMBER |
Used size in bytes, |
FREEB |
NUMBER |
Free size in bytes |
NFS_SERVER |
VARCHAR2(256) |
The server name for the NFS Server. |
NFS_SERVER_IP_ADDRESS |
VARCHAR2(256) |
The IP address of the NFS Server |
NFS_VENDOR |
VARCHAR2(256) |
The NFS Server vendor |
MOUNT_PRIVILEGE |
VARCHAR2(256) |
{READ|WRITE} This is the mount privilege of the filesystem. |