Batch size parameter for NmsBroadLogRcp

[Klaster]

Hi,

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

[Adhiyan · Accepted solution]

Hi Klaster,

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.

Regards,
Adhiyan