Greetings, CF-Talkers. We've recently been migrating a lot of our SQL code to our Oracle 8.1.7 database in the form of Stored Procedures. We currently run ColdFusion 5. Everything seemed to be going swimmingly. Yesterday, we began noticing significant performance slowdowns.
Apparently, the maximum number of Oracle connections specified in the server had been reached, and inactive connections were not being released automatically. We reverted to an older codebase without Stored Procedures, and restarted the server, but that's removed quite a bit of functionality. It seems as though every time we call (certain?) stored procedures, the oracle connection is **never** considered inactive and closes/releases, as it should. Changing the Connection Timeout to a lower number has no effect -- the inactive connections stay open to our Oracle Server indefinitely. We've searched extensively, through Macromedia and CF-Talk archives, but have found no mention of this occuring elsewhere. Have no idea which procedures are causing the problem, much less why ColdFusion would leave the connections open for good. Any suggestions? Thanks in advance. Barrett ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
