Hello Maximo Experts,
Happy New Year to All !!
Recently we migrated our database(Oracle 12 c) from Sun Solaris to RHEL X86 . After migration completed, We are facing database memory utilization issue.
When we checked with our DBA , They told that due to idle session in V$session table and these sessions are consuming memory ,hence the memory utilization reaching the highest level. So Maximo application servers are not able to connect to DB.
As per DBA the idle session are not getting cleared until restart the server or forcefully kill.
Now we have to fix this issue and I went through below IBM link
Maximo -- How to solve database connection leaks?and we have set below properties in system property application.
mxe.db.closelongrunconn - true
mxe.db.longruntimelimit - 60
mxe.db.detectlongrunconninterval - 30
After setting above properties ,Still no effect. The idle session are still remain in V$session table.
So we need your expert advise and suggestion to overcome this issue.
Thanks
Alok
#Administration------------------------------
Alok Pattnaik
Praxis Solutions
------------------------------