Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php <-> Oracle

2002-07-09 Thread Michael Bretterklieber
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

Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php<-> Oracle

2002-07-09 Thread Steve Farmer
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