Re: OPEN_CURSORS is getting out of hand!
Date: 2 Dec 1994 03:20:32 GMT
Message-ID: <3bm3q0$kk7_at_net.auckland.ac.nz>
We had that problem - it was caused by a bug in the database, resulting
in cursors not being closed. Version 6, on a SUN. There was a patch that
fixed it.
Its probably not the cause of your problem, but the possibility is
worth bearing in mind.
To see if it is anything like this, see if you can set up a test-situation
where you go into your app and back out to the same spot, then loop
around again...and monitor open cursors using sqldba monitor.
If its anything like this, you will see the number of open cursors at
a certain point in the loop, go up each time. If its just that the
app uses lots of cursors, and they are all getting closed OK, then
each time you return to that point, the number of open cursors should
be the same.
Hope this helps. (this problem caused me alot of grief !).
cheers
alan
Received on Fri Dec 02 1994 - 04:20:32 CET