Thursday, October 04, 2007

ORA-01000: maximum open cursors exceeded

Hitting maximum open cursors exceeded?
Read the following post by Natalka
http://orafaq.com/node/758
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!