oracle, apache and php - filedescriptors and sessions

From: Jan Gregor <gregor.jan_at_NOSPAMquick.cz>
Date: Wed, 20 Oct 2004 06:33:27 +0000 (UTC)
Message-ID: <cl50rn$1mu1$1@ns.felk.cvut.cz>

Hello,

We have php(4.3.8) program running under apache (1.3.x) that connects to oracle database throught oci functions. Program runs under solaris9.

Problem is that ociLogon produces still increasing number of filedescriptors to ocius.msb file in oracle client library. Usage of ociPLogon (persistent connection) on the other side lead to problem on oracle server - reached maximum number of oracle sessions.

Dirty solution is to kill php process in apache - specified as number of processed requests.

I found discussions about similar problem since 1998 and can't believe that oracle have this error minimally for 6 years.

Any advice ?

Jan Gregor Received on Wed Oct 20 2004 - 01:33:27 CDT