Hitting maximum open cursors exceeded?
Read the following post by Natalka
v$open_cursor and v$sesstat doesn't show the currently open cursors correctly. It includes the cursors 'marked for close' but not yet closed. Looks like there is no safe way to find the cursors really open!