Unbounded prepared statement pooling can bring Oracle to its knees
------------------------------------------------------------------
Key: GEOS-3727
URL: http://jira.codehaus.org/browse/GEOS-3727
Project: GeoServer
Issue Type: Bug
Reporter: Andrea Aime
Assignee: Andrea Aime
Fix For: 2.0.1
For most databases prepared statement caching is sort of cheap. For Oracle,
it's not, each prepared statement keeps a cursor open on the server side.
Cursors are usually limited by admins being expensive resources to keep around.
Expose a property to limit the number of cached prepared statements.
Limitless does not sound very good in general, we may want to provide this
property for any database that uses prepared statements.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
