EM 13c: High number of inactive sessions for DBSNMP user from OMS on target DB's
(Doc ID 3041405.1)
Last updated on AUGUST 13, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
High number of inactive sessions for DBSNMP user from OMS on target DB's leading to exhaustion of max sessions
Issue seen for OMS 13.5 RU 20/21
Below query, when run on the problematic target DB, confirms the inactive sessions belong to OMS that are not auto-closing.
SQL> select username,command,status,server,osuser,machine,terminal,program,module,count(*) from gv$session where username='DBSNMP' and status='INACTIVE' group by username,command,status,server,osuser,machine,terminal,program,module;
USERNA COMMAND STATUS SERVER OSUSER MACHINE TERMINAL PROGRAM MODULE COUNT(*)
---------------------------------------------------------------- ----------
DBSNMP 0 INACTIVE DEDICATED pzo000 <Hostname> unknown OMS OEM 175
DBSNMP 0 INACTIVE DEDICATED pzo000 <Hostname> unknown OMS OEM 219
Changes
OMS 13.5 running on RU 20/21
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 |
| Changes |
| Cause |
| Solution |
| References |