Skip Headers
Oracle® Enterprise Manager Extensibility
10g Release 2 (10.2) for Windows or UNIX

Part Number B16246-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

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:

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.

Access to this view will use an index if the query references the member target name, target type, metric name, and metric column or a subset of these columns if they are included as listed above from left to right.

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

MGMT$METRIC_DETAILS

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

MGMT$DB_TABLESPACES displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables.

Table 6-89 MGMT$DB_TABLESPACES

Column Datatype Description

HOST

VARCHAR2(256)

Name of the target where the metrics will be collected.

TARGET_NAME

VARCHAR2(64)

The type of target, for example, Oracle_ database.

TARGET_GUID

RAW(16)

The unique ID for the database target.

COLLECTION_ TIMESTAMP

DATE

The date and time when the metrics were collected.

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace.

CONTENTS

VARCHAR2(9)

Tablespace contents: PERMANENT or TEMPORARY.

STATUS

VARCHAR2(10),

Tablespace status: ONLINE, OFFLINE, or READ ONLY.

EXTENT_MANAGEMENT

VARCHAR2(10),

Extent management tracking: DICTIONARY or LOCAL.

ALLOCATION_TYPE

VARCHAR2(10),

Type of extent allocation in effect for this tablespace.

LOGGING

VARCHAR2(10),

Default logging attribute.

TABLESPACE_SIZE

NUMBER

Current size of the tablespace in bytes.

INITIAL_EXT_SIZE

NUMBER

Default initial extent size

INCREMENT_BY

NUMBER

Default percent increase for extent size.

MAX_EXTENTS

NUMBER

Default maximum number of extents


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.