Re: 8i, Linux and PHP

You probably won't have any entry for number of cursors in init<SID>.ora (at least I didn't). I had to add a line like 'open_cursors = 2000'. I'm not certain of the exact spelling and syntax because I don't use it any more. Instead, I make sure I close the DB connection at the end of every PHP page. You could use something like this at the end of every file (or in your auto_append_file):

if ( !empty($conn) ) { OCILogoff( $conn ) }

$conn is the connection id you will have received from your OCILogon() call.

that should solve your problem.

HTH,

• Kev

Lehmann wrote:

> 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 Fri May 26 2000 - 00:00:00 CDT