Bulk updating multiple columns in oracle
14-Sep-2019 13:14(DBMS_UTILITY.get_time - l_start)); -- Time bulk with LIMIT 100. (DBMS_UTILITY.get_time - l_start)); END; / Regular (42578 rows): 66 Bulk (42578 rows): 4 PL/SQL procedure successfully completed.
Instead you would limit the rows returned using the clause and move through the data processing smaller chunks.
This gives you the benefits of bulk binds, without hogging all the server memory.
The array size you pick will depend on the width of the rows you are returning and the amount of memory you are happy to use.