Re: ORA-01000 max cursors exceeded

O9 OEM Top Sessions has a selection for showing the open cursors in your session, so you can see exactly what is going on. Right click on the session and drilldown to open cursors for this session. That's one way, anyways. Right click on the cursor for an explain plan, FWIW.

I was recently using it to look at an app that had 218 cursors open. I don't think it was unreasonable, considering. There were certainly a number that didn't need to be there, and some were quite eye-opening. I have to take back what I said in another thread about never seeing small lookup tables anymore.

jg

--
@home.com is bogus.
'Perl is another example of filling a tiny, short-term need, and then
being a real problem in the longer term,' 'Once you have something that
grows faster than education grows, you're always going to get a pop
culture,' 'most undergraduate degrees in computer science these days
are basically Java vocational training,' 'All creativity is an extended
form of a joke,' and 'nobody really knows how to design a good
language.' - Alan Kay per /.