on 10-21-2020 7:04 AM
在sap里面通过dblink 向oracle数据插数据大概有70W条数据
已经优化到每500条提交一次,显示内存不足休息前请退出事务。
进入ST02查看 如下:
There are about 70W data inserted into oracle data through dblink in SAP It has been optimized to submit once every 500 entries. Please exit the transaction before taking a break when the memory is insufficient. Enter ST02 to view as follows How can I optimize? Or is there a link to related documents?
Screen swaps 362
Do you get this mesage "Please exit the transaction before taking a break" and don't know what it means? It means, the memory is getting low and as SAP only releases the memory once the work process is free again, you are asked to leave the transaction (=release the work process) to free the memory before you take a break and thus occupy the work process longer than needed. This is no error situation.
The handful of swaps in the screen buffer are not important. If you want to get rid of them, just increase the buffer a bit. You can decrease the EM if there is no mem left on os level, from the 23GB configured the peak use was just 9GB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
9 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.