6 Management Repository Views

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:

Overview
Monitoring Views
Inventory Views
Policy Definition Views
Policy Association Views
Policy Violation Views
Management Template Views
Job Views
Application Service Level Management Views
Configuration Views
Oracle Home Patching Views
Linux Patching Views
Security Views
Configuration Management Views
Database Cluster Views
Storage Reporting Views

Overview

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.

Using Repository Views

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.

Example 6-1 View Usage

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";

Monitoring Views

MGMT$METRIC_ERROR_HISTORY

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.

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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

MGMT$BLACKOUTS displays all blackout definition information along with current schedules.

Table 6-5 MGMT$BLACKOUTS

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

MGMT$ALERT_ANNOTATIONS displays a summary of alert annotations.

Table 6-6 MGMT$

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

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

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.

Usage Notes

List the metric collections for a given target.

MGMT$TARGET_METRIC_SETTINGS

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Ó.

Usage Notes

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

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

Usage Notes

Get the current availability status of a given target.

MGMT$AVAILABILITY_HISTORY

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

Usage Notes

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

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.

Table 6-12 MGMT$

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

Usage Notes

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

MGMT$ALERT_HISTORY displays historical information for any alerts that are logged in the Management Repository.

Table 6-13 MGMT$ALERT_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.
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

Usage Notes

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.

Queries that use the collection_timestamp or that query using the alert_state will also be indexed.

MGMT$METRIC_DETAILS

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

Usage Notes

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

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

Usage Notes

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

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.

Table 6-16 MGMT$METRIC_HOURLY

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.

Usage Notes

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

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.

Table 6-17 MGMT$METRIC_DAILY

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.

Usage Notes

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.

Inventory Views

MGMT$TARGET

MGMT$TARGET displays information about the managed targets that are known to the Management Repository. These targets may or may not be actively monitored.

Table 6-18 MGMT$TARGET

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.

Usage Notes

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

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.

Table 6-19 MGMT$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.

Usage Notes

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

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

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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

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

Usage Notes

List the properties applicable to the target and the default values.

MGMT$TARGET_PROPERTIES

MGMT$TARGET_PROPERTIES displays detailed target properties.

Table 6-25 MGMT$

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

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.

Usage Notes

Classify the metrics into different buckets based on Class and category.

Policy Definition Views

MGMT$POLICIES

MGMT$POLICIES displays the list of policies defined in the Management Repository.

Table 6-27 MGMT$POLICIES

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

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

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

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

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

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.

Policy Association Views

MGMT$TARGET_POLICIES

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

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Ó.

Policy Violation Views

MGMT$POLICY_VIOLATION_CURRENT

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

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

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.

Management Template Views

MGMT$TEMPLATES

MGMT$TEMPLATES displays details of all the management templates stored in the Management Repository.

Table 6-38 MGMT$TEMPLATES

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

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_METRICCOLLECTION

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

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Ó.

Job Views

MGMT$JOBS

MGMT$JOBS displays information about a job including the job's schedule.

Table 6-42 MGMT$JOBS

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

MGMT$JOB_TARGETS displays the target(s) the job was submitted against.

Table 6-43 MGMT$JOB_TARGETS

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

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

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

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

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.

Application Service Level Management Views

MGMT$CSM_REGION

MGMT$CSM_REGION displays a list of regions and their member targets.

Table 6-48 MGMT$CSM_REGION

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

Usage Notes

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

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.

Table 6-49 MGMT$CSM_WATCHLIST

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)

Usage Notes

List the URL watchlist for a given target

MGMT$CSM_METRIC_DETAILS

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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

MGMT$CSM_URL_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by URL in daily time periods.

Table 6-53 MGMT$CSM_URL_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	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

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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

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

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

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.

Table 6-60 MGMT$CSM_IP_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	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

Usage Notes

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

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.

Table 6-61 MGMT$CSM_IP_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	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

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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

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

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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

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

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

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

Usage Notes

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_DAILY

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

Usage Notes

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

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.

Usage Notes

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

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.

Usage Notes

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

MGMT$E2E_1DAY displays the E2E data where rollup time spans from 7 days to 31 days.

Table 6-76 MGMT$E2E_1DAY

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

MGMT$E2E_HOURLY displays E2E data where rollup time spans from 24 hours to last 7 days.

Table 6-77 MGMT$E2E_HOURLY

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

MGMT$E2E_RAW displays E2E data where rollup time is less than 24 hours.

Table 6-78 MGMT$E2E_RAW

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.

Configuration Views

MGMT$DB_TABLESPACES

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)

Usage Notes

Obtain control file configuration settings across all managed database targets.

MGMT$DB_DATAFILES

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.

Table 6-80 MGMT$DB_DATAFILES

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

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

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

Usage Notes

Obtain general instance information across all database targets.

MGMT$DB_FEATUREUSAGE

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.

Usage Notes

This view can be used to gain an enterprise-wide view of database feature usage across all Oracle databases.

MGMT$DB_INIT_PARAMS

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.'

Usage Notes

Obtain initialization parameter settings across all database targets.

MGMT$DB_LICENSE

MGMT$DB_LICENSE displays database license configuration settings. Database license configuration settings are collected from v$license.

Table 6-85 MGMT$DB_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.

Usage Notes

This view can be used to obtain database license configuration settings across all database targets.

MGMT$DB_REDOLOGS

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.

Table 6-86 MGMT$DB_REDOLOGS

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.

Usage Notes

Obtain redo log group / file configuration settings across all database targets.

MGMT$DB_ROLLBACK_SEGS

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.

Usage Notes

Obtain rollback segments configuration settings across all database targets.

MGMT$DB_SGA

MGMT$DB_SGA displays System Global Area (SGA) configuration settings. SGA settings are collected from the v$sga and v$sgastat tables.

Table 6-88 MGMT$DB_SGA

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

Usage Notes

Obtain System Global Area configuration settings across all database targets.

MGMT$DB_TABLESPACES

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

Usage Notes

Obtain tablespace configuration settings across all database targets.

MGMT$DB_OPTIONS

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.

Table 6-90 MGMT$DB_OPTIONS

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)

Usage Notes

Obtain tablespace configuration settings across all database targets.

Oracle Home Patching Views

MGMT$EM_HOMES_PLATFORM

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.

Table 6-91 MGMT$EM_HOMES_PLATFORM

Column	Datatype	Description
HOME_ID	RAW(16)	Unique id for home
PLATFORM_ID	NUMBER(10)	If the home has an ARU platform it is used, else the platform id of the host is picked
PLATFORM	VARCHAR2(1024)	The platform corresponding to the platform_id

MGMT$HOMES_AFFECTED

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.

Table 6-92 MGMT$HOMES_AFFECTED

Column	Datatype	Description
HOST	VARCHAR2(1024))	Host name
HOME_DIRECTORY	VARCHAR2(1024)	Home directory location
TARGET_GUID	RAW(16)	Unique id for target
ALERTS	NUMBER	Number of alerts for this home

MGMT$APPL_PATCH_AND_PATCHSET

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

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

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.

Linux Patching Views

MGMT$HOSTPATCH_HOSTS

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

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

MGMT$HOSTPATCH_GRP_COMPL_HIST displays information required to generate compliance history reports.

Table 6-98 MGMT$HOSTPATCH_GRP_COMPL_HIST

Column	Datatype	Description
GROUP_NAME	VARCHAR2(256)	Name of the Group
TOTAL_HOSTS	NUMBER(6)	Number of hosts in the Group
COMPLIANT_HOSTS	NUMBER(6)	Number of compliant Hosts in the Group.
LAST_CHECKED_ON	DATE	Date on which this record was collected.

MGMT$HOSTPATCH_HOST_COMPL

MGMT$HOSTPATCH_HOST_COMPL displays information required to generate advisory reports.

Table 6-99 MGMT$HOSTPATCH_HOST_COMPL

Column	Datatype	Description
HOST_NAME	VARCHAR2(256)	Host name
PKG_NAME	VARCHAR2(256)	Package name
VERSION	VARCHAR2(64)	Version of the package
IS_OUT_OF_DATE	NUMBER(1)	If out of date
IS_ROGUE	NUMBER(1)	If it is rogue

Security Views

MGMT$ESA_ALL_PRIVS_REPORT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

Configuration Management Views

MGMT$CSA_COLLECTIONS

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

MGMT$CSA_FAILED displays all failed collections.

Table 6-123 MGMT$CSA_FAILED

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

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

MGMT$CSA_HOST_SW displays all OS-registered software found on CSA hosts.

Table 6-125 MGMT$CSA_HOST_SW

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

MGMT$HW_NIC displays performance information for host hardware network cards.

Table 6-141 MGMT$HW_NIC

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

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

MGMT$OS_FS_MOUNT displays performance information for mounted filesystems.

Table 6-143 MGMT$OS_FS_MOUNT

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

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

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_PATCHES

MGMT$OS_PATCHES displays performance information for OS patches.

Table 6-146 MGMT$OS_PATCHES

Column	Datatype	Description
HOST	VARCHAR2(256)	The name of the host
OS_EXTENDED	VARCHAR2(352)	A summary column that includes update level and address length
OS	VARCHAR2(229)	A summary column that includes name and version
PATCH	VARCHAR2(128)	The name of the patch

MGMT$OS_SUMMARY

MGMT$OS_SUMMARY displays operating system summary information.

Table 6-147 MGMT$OS_SUMMARY

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

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

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

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_DEPENDENCIES

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

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

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

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

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

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

Database Cluster Views

MGMT$CLUSTER_INTERCONNECTS

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

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

MGMT$HA_BACKUP displays details of the latest backup of the databases.

Table 6-159 MGMT$HA_BACKUP

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.

Storage Reporting Views

MGMT$STORAGE_REPORT_DATA

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

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

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

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

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

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

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

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.