Oracle并发

可以用/*+parallel(a,8)*/来进行并发执行，提高执行速度，示例如下：

insert into tmp4 (region, user_id, ADJUST)
  select /*+parallel(a,8)*/ a.region, a.user_id, sum(a.adjust)
     from  bill
    where cycle_id = 201701
      and a.adjust <> 0 group by a.region,a.user_id;

/*+parallel(a,8)*/会被解析成8个进程来执行该语句，"a"代表并发的表,"8"代表并发的进程数。

转载于:https://www.cnblogs.com/lzp666/p/6513205.html