Hi,
We are facing the problem of maximum no on open cursors exceeded though we have changed the parameter OPEN_CURSORS to 4000. We have only stored procedures and packages in the application and we have ensured that all the opened explicit cursors are closed. But when we check the no of opencursors from v$open_cursor it is showing 2600. My question is:
We are using lot of "bulk collect into" into varrays and objects. Does this bulk collect internally retrieve data in cursors? If so, does it mean it opens one cursor for every record which is "bulk" fetched into?
We have also learnt that we can increase the parameter OPEN_CURSOR to 2000000 which doesnt add overhead. Will this enormous increase effect performance of the system.
Please help.
Regards,
Rajani.
