Calls Consuming Cpu But Have Wait Event= SQL*Net Message
(Doc ID 2619022.1)
Last updated on DECEMBER 10, 2019
Applies to:Oracle Utilities Meter Data Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
**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 v18.104.22.168
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.
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