Maximo Open Forum

 View Only
  • 1.  Maximo Idel Session Issue

    Posted 01-06-2021 10:59
    Edited by Alok Pattnaik 01-06-2021 11:34
    ​​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
    ------------------------------
    ​​


  • 2.  RE: Maximo Idel Session Issue

    Posted 01-07-2021 10:09
    Alok,  Can you provide Maximo version information?   IBM has implemented fixes for database connection issues over the last year, would help to know where you are at currently.

    ------------------------------
    Mark Eaton
    Projetech
    ------------------------------



  • 3.  RE: Maximo Idel Session Issue

    Posted 01-07-2021 10:18
    Hi Mark,

      Thanks for your reply. We are currently in maximo 7.5.0.7 , database 12c and weblogic 10.3.6.
    The main issue the idle session are keep remaining in the v$session table.It is not getting clear which leading to high memory utilization.

    Thanks


    Thanks 
    Alok

    ------------------------------
    Alok Pattnaik
    Praxis Solutions
    ------------------------------



  • 4.  RE: Maximo Idel Session Issue

    Posted 01-07-2021 13:25
    Alok,
    I've conferred internally and we are not aware of anything in Maximo 7.5 to adjust other than the items you mention.    Seems odd that a database instance change would make a difference unless there were Oracle parameters for maximum processes configured in the previous Oracle instance that did not get ported over to the new instance.    Bottom line, 7.5 is unsupported.  At this point, my recommendation would be to upgrade to Maximo 7.6.1.1 IFIX03 or higher.  Much work has been done by IBM at the framework level to address DB connection leaks since 7.5.0.7 and database connection resiliency is much better as of 7.6.1.1. IFIX03.

    Hope this helps!

    ------------------------------
    Mark Eaton
    Projetech
    ------------------------------



  • 5.  RE: Maximo Idel Session Issue

    Posted 01-21-2021 11:15
    Thanks Mark, we are on the process of upgrading.

    ------------------------------
    Alok Pattnaik
    Praxis Solutions
    ------------------------------



  • 6.  RE: Maximo Idel Session Issue

    Posted 01-12-2021 18:50
    Hi Alok,

    It could be a customisation issue which was may be suppressed by some oracle DB's forceful Session closure.
    I would insist on deeper investigation from DBA to find out if we can get the queries which are opening these uncleared sessions.

    Thanks,
    Biplab

    ------------------------------
    Biplab Choudhury
    Tata Consultancy Services
    ------------------------------



  • 7.  RE: Maximo Idel Session Issue

    Posted 01-21-2021 11:16
    Thanks Biplab for your time,sure we will look into it.

    ------------------------------
    Alok Pattnaik
    Praxis Solutions
    ------------------------------