• Post Reply Bookmark Topic Watch Topic
  • New Topic

oracle connection pool setting and database cursors  RSS feed

Amit Da
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using Oracle's connection pool for managing connections. After using a ResultSet or executing a DML statement, I close the ResultSet, Statement and also finally the connection object(logical connection obtained from pool) to free the resources.
But it was noticed that in database there were several INACTIVE CURSORs and at some point they even reached the MAX number set in init file. Does anyone know how to resolve this ?
I tried settings -
on the connection cache object and that gets rid of the CURSORs faster but I am not sure what would be the reasonable values. The first two methods take a long. Is that in milis/s/minutes/hours ??? what's the unit ? Is anyone using these methods and knows what would be good settings for an enterprise app pool that has a lot of database interaction and several users(50+) hitting database at same time ?
Code snippet of pool usage:
OracleConnectionPoolDataSource ocpds = new OracleConnectionPoolDataSource(); ocpds.setDriverType("thin");
OracleConnectionCacheImpl ocach = new OracleConnectionCacheImpl(ocpds);
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think it is because the physical connection is not closed.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!