Re: Oracle persistent connection limit
| From: | Thies C. Arntzen | Date: | Tue, 23 Jul 2002 18:32:05 +0000 |
| Subject: | Re: Oracle persistent connection limit | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109116@lists.php.net to get a copy of this message | ||
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