This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • 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