因业务表在数据转换时，相应的标识符没有加上，故需多进程对同一张表操作，从而提高更新的效率。
1、写好相应的存储过程：
create or replace procedure proc_update_XXX(being_num in integer,end_num in integer) is
cursor c_table is
select * from(
select a.*, row_number() over(order by rowid) rk from table a
) where rk>being_num and rk 'UPDATE_XXX_THREAD_' || X,
JOB_TYPE => 'PLSQL_BLOCK',
JOB_ACTION => STR_JOB,
ENABLED => FALSE,
AUTO_DROP => TRUE,
COMMENTS => 'proc_update_XXX_' || X);
DBMS_SCHEDULER.ENABLE(NAME => 'UPDATE_XXXX_THREAD_' || X);
end loop; UPDATE TMEMP_HADUPDATE_LCM_20140124
SET V_HAD_NUM =PRM_HAD_UPDATE + 100 *V_MAX_THREAD;
COMMIT;
END;