We are using roguewave connection pool in our application. Lot of inactive session is getting created in Oracle V$session table. Once count increases to 500 inactive session, we need to delete all rows from the v$session table in order to get our application working.
What can be done in order to stop creation of inactive session in Oracle v$session ? Is there any issue with roguewave connection pooling mechanism. Checked the application code and didn't find any issue. All connection is released to pool after being used.
It Rogue Wave a Java product? It looks like it is C++ Regardless of whether you use a connection pool or not, connections can still leak. You should look at your code and make sure you are releasing any connections that you have finished using.