OEDQ Inactive sessions are Not clearing on Database After OEDQ 12.2.1.3.0 upgrade
Hi Team,
We have running OEDQ jobs using JMX tool and all OEDQ jobs are running fine without any issue and it's finishing the jobs as well. But here the issue is whatever the database sessions are established from OEDQ after completing of the edq jobs the session which are established from OEDQ are going for Inactive state on Database. And those sessions are not getting cleared from database and inactive sessions keep on queued up on DB about 4000+ sessions within in 2 to 3 day's .At this movement DB will go for hung state and user not able connect to