My Oracle Support Banner

EM 13C: Huge Number Of INACTIVE Sessions Created From DBSNMP At Target Database (Doc ID 3010980.1)

Last updated on MARCH 27, 2024

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Cloud Control Creates Many Connections by the Database monitoring user : DBSNMP, get Accumulated in INACTIVE Status at  the Target Database.

These sessions sometimes consume the max processes parameter limit on the target database, affecting new connections to the database and resulting in Database Restart/Hung like Situations.

 

 

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.