try to use V$SESSION_CURSOR_CACHE
it has field OPEN: NUMBER --Current number of open cursors