only disadvantage is if the cursors are not closing properly in the application code then the open cursors keep filling the buffer. Usually this won't happen in the base application but if there is any customizations done then there is a good chance that developers are forget to close the cursors properly or just overlook.


Thanks,