Enterprise Manager Generic (MOSC)

MOSC Banner

EM rising of oms sessions

EMCC13.5.0.19, Oracle Linux 7.9.

On target databases there are a lot of inactive connections from oms server.

select username, machine, program, module, status

from v$session

where program='OMS';


1   DBSNMP   host  OMS   OEM   INACTIVE

2   DBSNMP   host   OMS   OEM   INACTIVE

3   DBSNMP   host   OMS   OEM   INACTIVE

4   DBSNMP   host   OMS   OEM   INACTIVE

5   DBSNMP   host   OMS   OEM   INACTIVE

6   DBSNMP   host   OMS   OEM   INACTIVE

7   DBSNMP   host   OMS   OEM   INACTIVE

etc.

I set up:

emctl set property -name oracle.sysman.db.perf.reposconn.inactivity_timeout -value "0"

emctl set property -name oracle.sysman.db.perf.reposconn.abandoned_connection_timeout -value "0"

emctl set property -name oracle.sysman.eml.maxInactiveTime -value 45

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center