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 laterInformation 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 |