In my experience, the problem usually is somebody that opens a cursor and then doesn't close it. After a while, the number of OPEN_CURSORS is exhaused for the session.