6 Management Repository Views

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.

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.

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.

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

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.

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

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.

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.

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

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

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

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)

Unqiue 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

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)

Unqiue 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

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

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

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.

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.

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.

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.

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 verision of the target type stored in the Management Repository.

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.

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.

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

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

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.

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.

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.

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

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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

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.

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

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.

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.

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.

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.

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.

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

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)

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.

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.

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

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

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.

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.

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

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

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.

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.

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

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

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.

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.

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

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

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.

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.

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

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

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.

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.

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

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

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.

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.