I have seen one situation with oracle and cf 7 (on solaris) with "maintain connections" ticked in the admin. It looks like CF can't tell when oracle drops the connection and then it tries to use that connection again and an error is thrown in the logs. I haven't seen it lock up a server or anything like that. Also you said that your limiting connections, are you doing this to help out the DB server? is there an issue there? Decreasing the connections may cause the server to start queuing requests (which may appear as a lockup to the user, however, the server should come back with responses eventually).
Another thought on maintain connections, it could be with all your apps that coldfusion is competing with itself to get connections to the db server and is waiting in peak times for connections to open up. Really though, there are a bunch of unknowns here that may require you to put something like seefusion or the like on the server so you can really see what exactly is going on. -Steven On Tue, Apr 29, 2008 at 10:51 AM, Fox, Andrew J <[EMAIL PROTECTED]> wrote: > I've got a question about limiting connections for a datasource and > overall performance. We've got a production CF server hosting a bunch of > apps, a few of which are having heavy loads at the same time. One > application in particular seems like it might be causing CF to lock up. It > is a student survey app and one professor is having his students fill it out > in a lab. We've searched through the CF and Apache logs and don't really > see any other suspects. > > > > We're running on Solaris 10 and hitting and Oracle 10g database. For this > datasource, we have the number of connections restricted to 6. > > > > If anyone has any suggestions on other things to check or if something in > our setup jumps out as "bad", I'd appreciate the feedback! > > > > Andy Fox > > Systems Analyst III > > OIT-EIS Georgia Tech > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- -- Steven Ross web application & interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] (404) 592-6885 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
