Calls Consuming Cpu But Have Wait Event= SQL*Net Message
(Doc ID 2619022.1)
Last updated on JUNE 26, 2024
Applies to:
Oracle Utilities Meter Data Management - Version 2.1.0.3 and laterInformation in this document applies to any platform.
Symptoms
**Examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:
MDM - Oracle Utilities Meter Data Management
CPU - Central Processing Unit
SQL - Standard Query Language
DBA - Database Administrator
On MDM v2.1.0.3
Calls consuming CPU but have wait event= SQL*Net message
Seeing a bunch of active sessions with with SQL IDs related to D1-PayloadSummary. These sessions are stuck with long waiting times and as per the DBA it continues to consume resource.
The problem is intermittent and there is no other solution than to restart the database and the application. It is unknown yet as how the problem occurs.
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 |