EM 12c: Loader Throughput (Rows Per Second) For Loader_D Exceeded the Critical Threshold in Enterprise Manager 126.96.36.199 Cloud Control
Last updated on JANUARY 05, 2018
Applies to:Enterprise Manager Base Platform - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 12.1]
Information in this document applies to any platform.
Receiving a critical alert for the Loader Throughput(rows per second) metric. For example:
This metric is run against the Oracle Management Service (OMS) and evaluates the average number of rows processed by the Loader (D) channel per second.
An incident will also be created for example:
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:
- Log into the Cloud Control Console
- Click on Setup > Manage Cloud Control > Management Services
- click on "oracle management service"
- click on "monitoring"/all metrics
- expand "active loader status"
- view "Loader Throughput (rows per second)" chart
By default this will show the data from last 24 hours, example:
Last known value:48.7 (critical)
The 'real time' data can be retreived as follows:
- click on view data: "real time"
- Highlight the loader_d row (3rd row)
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
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