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 19, 2022
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:
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 <OMS_HOSTNAME>.<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:
low value:30.82
high value:233.9
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
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |