EM 12c: Loader Throughput (Rows Per Second) For Loader_D Exceeded the Critical Threshold in Enterprise Manager 12.1.0.1 Cloud Control (Doc ID 1433146.1)

Last updated on AUGUST 03, 2016

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 to 12.1.0.1.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Receiving a critical alert for the "Loader Throughput(rows per second)" metric.  For example:-

Loader Throughput (rows per second) for Loader_D exceeded the critical threshold (75). Current value:48.7

This metric is run against the "Oracle Management Service" and evaluates the average number of rows processed by the Loader (D) channel per second.

An incident will also be created for example:-

ID    3932
Metric    Loader Throughput (rows per second)
Loader Name    Loader_D
Target    omsmachinename.domain:4890_Management_Service(Oracle Management Service)
Incident Created    24-Apr-2012 22:17:37 CEST
Last Updated    24-Apr-2012 22:17:37 CEST

To see what the actual value of this metric is:-

By default this will show the data from last 24 hours, example:

av value:74.14
low value:30.82
high value:233.9
Last known value:48.7  (critical)

The 'real time' data can be retreived as follows:-

Note: the "loader Name" is not shown - Due to unpublished bug 12764915  the "real time" data chart will not display and gives ""error retreiving information from database.  Exception: No data available."  but the real time data is shown in the "last collected value" and "last collected timestamp" section:-

Last Collected Value    58.24
Last Collected Timestamp    25-Apr-2012 12:43:56 CEST

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms