[EMAIL PROTECTED] wrote: > We are having a problem with the oracle sessions running wild. We > have five web servers that run 6 servers.
> StartServers 6 > MaxClients 32 according to the your settings you _start_ 6 servers (well, child processes). you allow up to 32 processes (each with it's own cached database connection) with MaxClients 32. http://httpd.apache.org/docs/mod/core.html#maxclients so the max number of cached connections that you should see is 160. but as pointed out by the other response in this thread, that 160 is only the number of _absolutely identical_ DBI connect strings. make one connection as user foo and one as user bar and you're up to 320 connections. make other connections with different AutoCommit or RaiseError settings and you've got a whole lot of connections sticking around. one way around this is to change your code such that each DBI connect is minimal, then setting database attributes later as required. my $dbh = DBI->connect('dbi:Oracle:HELM', 'user', 'password'); local $dbh->{AutoCommit} = 0; local $dbh->{PrintError} = 0; HTH --Geoff -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
