• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

RogueWave connection pooling inactive session Oracle V$session

 
Srivastava Praveen
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanks in advance.
Praveen
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you want more help on Rogue wave, you'll need to provide a link. I'm confused.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic