Re: Oracle persistent connection limit

That is what I figured. The problem is that oracle doesn't even seem to have per-process limits. Eric On Tue, 23 Jul 2002, Thies C. Arntzen wrote: > On Tue, Jul 23, 2002 at 11:00:43AM -0700, Eric Thelin wrote: > > Is there a way to limit the total number of persistent connection to an > > oracle database? I know this functionality exists for MySQL through a > > setting in the php.ini but I haven't found it for oracle. I am in an > > environment where we have about 10 users that connect to oracle from > > each of 10 webservers that each have about 20 apache processes and I > > would like to use persistent connections but the resulting 2000 > > connections would overwhelm oracle. I am looking at reducing the number > > of users but that will be a large undertaking to go through the entire > > codebase. Any ideas? > > even the mysql-limits are _per_ apache-process. so if you > want to limit the simutainious connections to any php > supported database is to set MaxClients (in httpd.conf) or > disable persistent connections completely. > > re, > tc >