[PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle

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

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

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$,sga