I have found that table NmsBroadLogRcp is updated in batches
For ex. like
UPDATE NmsBroadLogRcp SET iStatus=:1, iMsgId=:2, tsEvent=:3, tsLastModified=cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId=:4 AND iStatus=:5 AND ROWNUM<=5000
I'm looking for solution how to manage batch size to avoid too many loops.
Those value is any defined parameter ?
Thanks in advance
Are you using mid-sourcing to send deliveries. If yes , there should be an option called NmsMidSourcing_LogsBatchSize
which can be changed to manage size of batch per SOAP call.