max_persistent: how set with oci??

riese

hi folk,

i have a quite urgent problem:

we're using oci with an adserver and just a few secs after startin apache, we get db errors saying too many connections open.

lokking at the oracle i find out that there are 200 (!) open connections.

i found uodbc.max_connections and set it to 50, but this doesn't work for oci and there's no oci-section in php.ini.

how can i create a connection pool for oci?
or
how can i limit the CONNECTIONS (not the cursors) in oci?

this is quite urgent...

cheers riese

Anon

Hi,
Are you using OCILogon? or OCIPlogon?

OciPlogon is the pooled connection for Oracle one connection per apache process.

However, I have been using OCIPlogon for a while, and found that sometimes, the connection fails mysteriously. After 6 months of using OciPlogon I have now finally moved back to OciLogon, and things are better now.
If you are using Cursors, then its important you free the cursors at the end of the page.

Regards,
Ronnie

riese

errm, ociplogon.

first of all, thank you.

we once decided to use *Plogon because it works faster. (not every page must open a connection which takes up to 2 secs...).

but is there a possibility for connection-pooling (analog to java)?

because there's a lot traffic on that site, and nearly every object need db...

Anon

Hi,
Well when you use OCIPlogon, my understanding of what happens is...

For every apache process, one oracle connection is created. Hence when the load on your web site increases, apache spawns more processes and hence more oracle connections are created. However as the load reduces the apache process dies, and so the oracle connection is terminated. This seems to be a good mechanism for connection pooling.

However, I have had some odd things happening with this on my web site, after running under hevy load for over 9 months on PHP-Oracle. Finally, I have switched to OciLogon and it seems to be doing fine.
But, then again, I am doing element level file system caching on each page.

However, I have bench marked ociplogon against ocilogon and didn't find too much a difference.

riese

good hint, thank you indeed :o)