Question

我正在就Oracle 10gR2开展工作。

我的问题是:

我有一份程序,请打电话*proc_other*。 (在一揽子方案中)本应称为另一种程序,请打电话* 用户_ 娱乐*。我不得不在座右栏内打上*user_production*,读上表上的一些栏目,这些栏值作为参数传到*user_production*程序。

这部法典就是这样:

FOR i IN (SELECT    community_id,
                        password,
                        username 
               FROM     customer 
               WHERE    community_id IS NOT NULL 
               AND      created_by =  SRC_GLOB 
              )
     LOOP
        user_creation (i.community_id,i.password,i.username);
     END LOOP;

COMMIT;

用户-申请程序正在以某种业务逻辑为由使用网络服务,然后根据答复更新表格。

我需要找到一种办法,使我能够在这里进行多面阅读,以便我能够利用这一程序来加快事情。我知道,我可以使用*DBMS_SCHEDULER*,并可能使用*DBMS_ALERT*,但我无法说明如何在座右边使用。

谁能指导我正确方向?

Thanks, Ankur

Answer 1

我愿结束这一问题。 DBMS_SCHEDULER 以及DBMS-JOB(尽管优先选择DBMS_SCHEDULER)可在休息室内用于提交和执行工作。

例如,此处采用可在休息室内援引的房舍管理处-JOB样本代码:

...
FOR i IN (SELECT community_id,
                 password,
                 username
          FROM   customer
          WHERE  community_id IS NOT NULL
          AND    created_by =  SRC_GLOB 
         )
LOOP
DBMS_JOB.SUBMIT(JOB => jobnum,
                WHAT =>  BEGIN user_creation (i.community_id,i.password,i.username); END;       
COMMIT;
END LOOP;

在SUBMIT之后使用的承诺将同时放弃工作(并因此成为程序)。

Answer 2

你可以做的是同时提供大量的工作。见Example 28-2 Creating a Set of Lightetter Jobs in aalone Transaction

This fills a pl/sql table with all jobs you want to submit in one tx, all at the same time. As soon as they are submitted (enabled) they will start running, as many as the system can handle, or as many as are allowed by a resource manager plan.

The overhead that the Lightweight jobs have is very ... minimal/light.

友情链接