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 tov$open_cursor):

 select  sql_text, count(*) as "OPEN CURSORS", user_name from v$open_cursorgroup 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.