On Wed, 20 Apr 2005 13:53:03 -0600, "Reidy, Ron" said: > [rr] I was testing on a DB instance where I was the only user at that > time. I did not bother to check v$sesstats (I probably should have), > but I will leave this to your testing.
OK. I'm not sure what the difference is, but in any case it looks like I'm running up against the limit described in the docs you posted below. > So my question is, when Oracle tells me I've exceeded the maximum > cursors limit, am I exceeding a limit of "really open" cursors or a > limit of "have been opened" cursors? > > [rr] From the 9.2 docs: <snip OPEN_CURSORS section of Oracle 9.2 docs> Thanks for that. That's definitely the limit I'm running up against. Now if I could only figure out how to close my cursors... Mike
