My Oracle Support Banner

Performance spikes on ECE DB (Doc ID 3020787.1)

Last updated on MAY 10, 2024

Applies to:

Oracle Communications BRM - Elastic Charging Engine - Version 12.0.0.4.0 and later
Information in this document applies to any platform.

Symptoms

One user is facing the performance spikes on Elastic Charging Engine (ECE) DataBase (DB) for both Site1 and Site2 on daily basis. These spikes are noticed after Cloud Native (CN) Go Live and happened on couple of months back.
After CN go-live, the other wait events class on Oracle Enterprise Manager (OEM) monitoring tool also in Active Session History (ASH)/Automatic Workload Repository (AWR) reports.

For example, below 2 wait events are reported:
1) enq: CR - block range reuse ckpt
2) enq: DW - contention

Dead locks are also observed in the alert log during the spikes.

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.