Hi all,
Does anyone know how many sessions can be opened by apache/php to
Oracle using OCIPlogon, or what parameter setting controls this?
TIA
Steve
--
-
Minds are like parachutes, they work best when open
Support free speech; visit
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
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$,sga