Two Laptop Bag*
The moose likes JDBC and the fly likes RogueWave connection pooling inactive session Oracle V$session Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "RogueWave connection pooling inactive session Oracle V$session" Watch "RogueWave connection pooling inactive session Oracle V$session" New topic
Author

RogueWave connection pooling inactive session Oracle V$session

Srivastava Praveen
Greenhorn

Joined: Aug 14, 2007
Posts: 14
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

Joined: Mar 06, 2001
Posts: 13459

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

Joined: Mar 06, 2001
Posts: 13459

If you want more help on Rogue wave, you'll need to provide a link. I'm confused.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: RogueWave connection pooling inactive session Oracle V$session
 
Similar Threads
Open Cursor Exceeded in Oracle
Regarding Oracle process
Connection Pools won't recycle connections
re:java.lang.Exception: ORA-00020: maximum number of processes (150) exceeded?
What does a SessionFactory object cache?