The UPDATE SWLY_OCAEXPLICIT SET ROUTE=F_Getallroutedescribebyid (PORT_SID, 0);

CodePudding user response:

Loop every 2-5000 records the batch updates, don't be a one-off,

CodePudding user response:

If the database version & gt;=11.2 May consider dbms_parallel_execute and stuff