Sapporo wrote:
Hi,
I'm trying to avoid excessive database connections within my app.
From the docs, I figured that the following code would insert 2 rows
of data into table Dummy, since the connection would be reused and the
transactions aren't isolated by using OCINLogon() (error handling lef
the first OCIexecute($statement, OCI_DEFAULT);
has not been commited
so when you reconnect , your cursor is closed and rollbacked with the 2nd PLogon
-Message d'origine-
De : Sapporo [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 9 juillet 2003 16:03
À : [EMAIL PROTECTED]
Objet : [PHP-DB]
Hi,
first we when we started up with oracle we had problems with these params:
processes, open_cursors, max_enabled_roles
After a week or so oracle was not able to allocate shared memory,
something like this:
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","TRIGGER$","s
Hi Michael,
So what you are saying is that apache/php will keep opening sessions
until oracle runs out of processes or cursors or memory or hits
session_per_user maximum ??
I was thinking of experimenting with the profile parameter IDLE_TIME
Profile Parameter to make oracle close open session