HI,
after migration from Linux to AIX 7.3 platform (Oracle 12.2c EE → Oracle 19.22c), we encountered a problem with executing a correct merge. The file contains details, but in general the problem is that the merge for a small number of rows, let's say up to 5000 rows, is performed correctly and most importantly enters the correct records, but for a larger number it is not, i.e. there are no errors, but the NVL2 function NVL2(K.ZIP_CODE,SUBSTR(K.ZIP_CODE, 1, 2) || '-' || SUBSTR(K.ZIP_CODE, 3), NULL) AS ZIP_CODE returns NULL, for a smaller number it does a merge and enters the zip code.
It does not matter whether it is done with an update or insert.
I have already wondered about the PRE_PAGE_SGA parameters, whether there is some conflict here, but at the moment everything is in the realm of guesswork.
I don't want you to spend too much time on this, because maybe the problem is in the data, but if you have any ideas, I would be grateful for your tips.
Interestingly, after adding sorting by the column on which the join occurs, the update worked correctly!!!
Does anyone know why?
sqlmonitor_99x19tg8j1f2d_16777218_1732714820323.sql