Hi PAVB,

currently open_cursors=2000

Is v$open_cursor is the right view to find the open cursors group by SID? I want to gather some evidence which session is keep on opening cursors and not closing before go back to my development team.

I believe Oracle cleans the open_cursors based on it's famous LRU algorithm. Is there any way or any hidden parameter to tell Oracle to clean the open cursors if they are not being reused for a certain period of time?

Thanks,