Check your session_cached_cursors and open_cursors options. These represent the number/session. so in your case the total seems to be almost there when you add up all the cursors/session. If you feel that the value is too high, check to make sure the following.
1. reduce the # of open cursors per session
2. session cached cursors
Sam




Reply With Quote