Hi there,
I have the following problem with this config :
Apache PHP 3.17
Oracle 8.1.6
on Sun Solaris.
When I am using Persistant logon 'PLogon', evrything works fine, but the number of DB connections opened (table v$session) exceeds 75 = the number of httpd process running (limited by the MaxClients on Apache) and reaches more than 300. Thus I am using too much of the DB ressources and as I share it with other web applications of my company, it is not a good way to drive things.
Then I decided to use standard 'Logon', and the connection is opened/closed for every PHP script. But the Oracle listener doesn't seem to handle so much request (about 300 000 per day) and the whole DB is down (a Oracle Cluster, 8 processor !).
Any explanation ?
I agree that PLogon might be better but why is it opening more session than the number of httpd process ?
Another tips : as soon have we have an error during a Logon or Plogon, the httpd process generates a zombie process. Is it a leak in PHP 3.x or a known 'bug' in the OCI8 API ?
I have the following problem with this config :
Apache PHP 3.17
Oracle 8.1.6
on Sun Solaris.
When I am using Persistant logon 'PLogon', evrything works fine, but the number of DB connections opened (table v$session) exceeds 75 = the number of httpd process running (limited by the MaxClients on Apache) and reaches more than 300. Thus I am using too much of the DB ressources and as I share it with other web applications of my company, it is not a good way to drive things.
Then I decided to use standard 'Logon', and the connection is opened/closed for every PHP script. But the Oracle listener doesn't seem to handle so much request (about 300 000 per day) and the whole DB is down (a Oracle Cluster, 8 processor !).
Any explanation ?
I agree that PLogon might be better but why is it opening more session than the number of httpd process ?
Another tips : as soon have we have an error during a Logon or Plogon, the httpd process generates a zombie process. Is it a leak in PHP 3.x or a known 'bug' in the OCI8 API ?