Avatar

Level 2

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