Re: 8i, Linux and PHP

The oracle instance is probably set up to limit cursors to 200 (in init<SID>.ora). Expanding the cursor limit is not the solution... Are you sure that PHP script disconnects nicely form the oracle instance?. This might be your problem. Check v$session view when Oracle is "blocked".

Good luck!

/Lehmann

"Karel Miklav" <karel_at_inetis.com> wrote in message news:v4vW4.4857$ep.129860_at_news.siol.net...
> I have an application in PHP with really bad attitude. Afer some time it
> opens so many connections (200) that my Oracle is blocked. When PHP script
> is waiting for query results a bit longer, Oracle (or somebody between
 them)
> returns plain null values. How the hell can that happen? Is there any
> PHP/Oracle tutorial or a document to learn how exactly connections should
 be
> opened, released, when to commit etc? Sites with low frequence of queries
> seem not to have these problems.
>
> Thanks, Karel Miklav
>
>
Received on Thu May 25 2000 - 00:00:00 CDT