Oracle PL/SQL:阻止并行执行 [英] Oracle PL/SQL: block parallel execution

问题描述

我有这样的程序.

create or replace
Procedure PROCEDURE_NAME
begin

Insert Instructions

Insert Instructions

Insert Instructions

Some Instructions

Some Instructions

Some Instructions


end;

以上内容是可以并行执行而没有任何冲突的指令块.如何在Oracle Procedure中定义以并行执行它们?

The above shall be instruction blocks which can be executed parallel without having any sort of conflicts. How can I define in Oracle Procedure to execute them in parallel ?

我可以为它们创建不同的过程，但是在此过程中寻求最小的修改，我相信可以在SQL中并行调用指令.

I can make different procedures for them but looking for minimum modification in this procedure, I believe to call instruction parallel in SQL is possible.

推荐答案

可以通过DBMS_Scheduler链并行执行多个过程.这些允许根据其他过程的成功或失败执行一系列过程.

Executing multiple procedures in parallel can be done through DBMS_Scheduler chains. These allow a series of procedures to be executed based on success or failure of other procedures.

Oracle的SQL Developer具有图形界面来提供帮助，尽管我总是亲自亲自对其进行编码.

Oracle's SQL Developer has a graphical interface to help with it, although I've always coded them by hand myself.

文档.

这篇关于Oracle PL/SQL:阻止并行执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！