Re: Problem PHP3 + Oracle 8i

On Mon, 10 Dec 2001 10:43:02 -0500, Martin wrote:

> Hello
>
> I'm working on some web services, I use two sun solaris OS: SUN OS 5.7,
> PHP3 and an oracle database 8.1.6.
>
> I'don't understand:
>
> I often have this error:
> OCISessionBegin: ORA-00020: maximum number of processes (250) exceeded
>
> I check the table v$process and i have 247 process, so I set the process
> to 600 and the open_cursor to 1000 in order to see if it still grows...
>
> To day, I have 580 process. I think, I will see the ORA-00020 error
> again. I only have 20 sessions..
> So I think that the process are not released, but why? Are there anything
> to free this process
>
> If someone have any idea?
> Do you think the client configuration( the two sun) is wrong or the
> database as some bad paramaters?
>
> Martin
>

Are you, by any chance, using OCIPLogon? That will open a new dedicated server connection whenever you issue that command. Anyway, you cannot preserve connection between processes which means that you have to re-issue OCILogon at every new page (you can make username, password and dbname session persistent). Using OCIPlogon instead of OCILogon will quickly accumulate processes. Make sure that your httpd processes are connecting through the MTS.

-- 
Mladen Gogala