Hi everyone, I would be so greatful if someone could offer me any suggestion.
system setup:
I am using php4.0.3pl1 / apache_1.3.12 / oracle8.1.5
program setup:
I use crontab to run a bunch of php page
to read data from files into the database.
problem ONE:
My program makes huge number of select statements out of the database. When I use ora_logon(), I still get a whole bunch of defunct at the OS level. Actually as the page load, you can see the number of defunct increase with the command 'ps -aux | grep defunct | wc -l'
(solution tried, but didn't solve the problem)
(1) compile with --with-sigchild
(2) using ora_close() and ora_logoff()
problem TWO:
If i switch to using ora_plogon(), I no longer get defunct at the OS level. However, now I get too many open files at the OS level. These file do not close even after the page finishes loading.
(solution tried, but didn't solve the problem)
(1) compile with --with-sigchild
(2) using ora_close() and ora_logoff()
Again, I have been working on this problem for 1 1/2 weeks, and am about to pull my hair out. I would certainly appreciate and am willing to try ANY SUGGESTION. Thank you.
-Will
