Business requirements on the project, to multiple threads thread (around 1000), can be carried with the update table set column2=value2 where column1=? ;
In the relationship between individual threads appear serial wait, cause the thread block, consult bosses if there was any tuning scheme, whether can use on the function of redis, if use redis, how with oracle synchronous data?

CodePudding user response:

Update the same data must be waiting,
But look at your SQL, different thread execution, column1 value should be different, the same record is how?