Premise:
foreground runs the program and processes 10 million pieces of data.

status:
will extract 10 million pieces of data from the database to the inner table, if a one-time extraction will occur memory TSV_TNEW_PAGE_ALLOC_FAILED dump.
that is: select XXXX
into table XXX
where…

if the package size is adopted, 1 million pieces of data are extracted once and processed.
select XXXX
into table XXX
package size 1000000
where…

perform XXXX “processed the 1 million pieces of data.

Endselect.

service really needs under the premise, the solution can only ask basis to change the kernel parameters, either to increase the buffer, or to extend the front running time.