Thanks Gtcol.

I have taken the report from v$open_cursor and provided the list to the development team to check the code and close all the cursors properly. They have fixed some code and i can see the significant improvement now.

Thanks,