My Oracle Support Banner

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 later
Information 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


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