Check V$OPEN_CURSOR, it has the cursor each session has open.