If you are using Oracle, you might have faced the following error sometime during the development/testing cycle.
ORA-01000: Maximum open cursors exceeded
How do you check for open cursors in the Oracle database? And how can you find out what part of your application is using/wasting these cursors?
Run the following query (remember you should select access to
select sql_text, count(*) as "OPEN CURSORS", user_name from v$open_cursor
group by sql_text, user_name order by count(*) desc;
The result will tell you the SQL used and also the OPEN CURSORS used by the corresponding query.