Also, you can query your Oracle DB to get the currently open connections. Look here to see if your limit of 6 connections for that particular user is getting hit often indicating many issues one of which could be not enough connections for your load. If you are using Oracle's SQL Developer, there is a pre-defined query for this already. If using Toad, there is a view for this too, though I can't recall where. You will need permissions to the appropriate v$ tables.
DK On Tue, Apr 29, 2008 at 12:28 PM, Steven Ross <[EMAIL PROTECTED]> wrote: > 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- > -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ------------------------------------------------------------- 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 -------------------------------------------------------------
