Hi all, I am having difficulty with inconsistent php-oracle connection.
At the beginning of each php page, i set the environmental variables(ORA_HOME, ORA_SID, TSN_ADMIN) with putenv(...).
A connection class is created and used by each components (modulized code),
The connection class used ora_plogon, ora_open, execute some sqls, execute some different sqls, ora_close, ora_logoff.
Multiple component are then added to differnt php pages.
The Linux, Oracle 8i, apache, php 4 beta, sometimes run very clean and fast. However, at times you can see
the loading bar on Internet Explore moving very slowly, and almost never get a connection, and almost
always gives a connection timedout message.
(and I end up having to close the IE and reopen another one, and this does not insure another clean connection either).
I am not sure if my connection class is using the oracle resource
wisely. What I mean by this is, that by itself, the connection class is efficient.
execute some sql query
execute some different sql query using the same cursor
However, lots of my pages include 5 or 6 components, each using an instance of the connection class. Is what I am
doing defeating the purpose of persistent connection? I would appreciate it if you could give me some feedback,