Thanks a lot for the response, Greg. I poked around quite a bit in the
PEAR::DB source, and everything at first glance looks OK. Connections are
closed properly, etc.
After doing a little more digging on the Web, I noticed a mention to remove
any reference to "SERVER=DEDICATED" from Oracle's tnsnames.ora file. I did,
and it seems to have helped... though I'm not convinced.
From: Greg Skouby [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 3:28 PM
To: Shawn Coomey
Subject: RE: [PHP-DB] OCI8 Memory Leak?
We are using almost the exact same setup that you describe without the PEAR
abstraction. We host a moderate sized application on this box and it has
performed flawlessly. My first indication, though I don't know why it would
be happening, is that there is a problem in the PEAR abstraction level.
From: Shawn Coomey [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 11:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] OCI8 Memory Leak?
I am building an application which uses OCI8 functions (abstracted with
PEAR::DB) to perform queries against an Oracle 9i database. Here's my
Solaris 8 (SunOS 5.2) on a Sun Ultra II workstation
Here's my problem:
Everything works well, but over time the Apache httpd processes start to
huge amounts of memory: for instance: I checked this morning and each of the
apache processes running were using over 125MB per instance, and the server
had slowed to a standstill. The processes upon restart use between 15-20MB
Is there something in the Oracle client configuration or in php/pear that
lead to this sort of memory problem?
Any help is greatly appreciated.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php