Premise:
foreground runs the program and processes 10 million pieces of data.
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. |
Read More:
- Insert datagram error: ISAM error: no free disk space
- Arithmetic overflow error converting identity to data type int
- [Oracle] when inserting data, “ora-00001: unique constraint” appears
- (error when importing database): MySQL 2006-mysql server has gone away
- Export and import method of MySQL under Linux
- Mysql cannot allocate memory for the buffer pool solution
- Oracle quick replacement undo table space method
- Dm7 Dameng database dmrman reports an error OS_ pipe2_ conn_ Server open failed solution
- ORA-01144: File size (39321600 blocks) exceeds maximum of 4194303 blocks
- Oracle data file space release
- mysql ERROR 1050 (42S01): Table already exists
- TypeError: ‘numpy.int64′ object is not iterable ,’int’ object is not iterable
- About MySQL error: subquery returns more than 1 row
- tf.layers.conv1d Function analysis (one dimensional convolution)
- Error: request failed with status code 500
- 12-web security — error injection based on SQL Server — and, convert, cast
- Error: can’t locate revision identified by ‘xxx’
- How to prevent duplicate submission
- Oracle can’t start the database due to deleting DBF file by mistake
- mysql error 1093