Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Too many open cursors
It is not set. Would that be in the init?
In article <7oubvv$pgt_at_romeo.logica.co.uk>,
"Hans den Broeder" <broederh_at_logica.com> wrote:
> what about your cursor_space_for_time ?
>
> todd.bandrowsky_at_conectiv.com wrote in message
> <7osdmg$j7t$1_at_nnrp1.deja.com>...
> >I am running normal Oracle 8 with the web application server on a Sun
> >Enterprise 3500 box.
> >
> >I keep getting "maximum open cursors exceeded", have the limit set at
> >500, and think that the problem is in my applications. So, I am
going
> >to ask a few basic questions in hopes that I can fix this. Your help
> >would be much obliged?
> >
> >a. What is the cursor lifetime in the context of a PL/SQL web
> >application server cartridge? I take that if I have a package, and
it
> >gets called by the web server, cursors not explicitly closed by that
> >package remain open forever and ever. Is this is true? What about
> >implicit cursors?
> >
> >b. What sort of cursor caching behavior does web application server
> >do? Is it possible to have a configuration where the number of
cursors
> >managed by the web pl/sql cartridge exceeds the actual database
limit?
> >If so, how does one fix?
> >
> >c. Part of our system includes a normal OCI program. Let's assume
for
> >a moment that it is buggy and exits and disconnects without closing a
> >couple of cursors. Do cursors close on disconnect?
> >
> >d. Off the wall. What's the easiest way to get a persistent
> >connection for a C++ CGI that uses OCI?
> >
> >e. Back to topic. Is there a programatic way to determine which
> >cursors have been left open by a particular application. I was
> >thinking having some sort of a query against V$OPEN_CURSOR, but
> >evidently that table does not have every cursor in it.
> >
> >Your help is greatly appreciated.
> >
> >Thanks!
> >
> >todd.bandrowsky_at_conectiv.com
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Aug 13 1999 - 09:33:57 CDT