利用job并行执行Oracle存储过程

2019-05-25 19:42:27 浏览数 (1)
  1. -- 建立测试表
  2. CREATE TABLE t (a NUMBER);
  4. -- 建立存储过程
  5. CREATE OR REPLACE PROCEDURE p_parallel (p_min IN NUMBER, p_max IN NUMBER)
  6. IS
  7. BEGIN
  8. INSERT INTO t
  9. SELECT TRUNC (DBMS_RANDOM.VALUE (p_min, p_max)) FROM DUAL;
  11. COMMIT;
  12. END p_parallel;
  13. /
  15. -- 建立job
  16. DECLARE
  17. x NUMBER;
  18. BEGIN
  19. sys.DBMS_JOB.submit (
  20. job => x,
  21. what => 'p_parallel(1,20);p_parallel(21,40);p_parallel(41,60);p_parallel(61,80);',
  22. next_date => TO_DATE ('14-05-2013 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
  23. interval => 'trunc(sysdate 1)',
  24. no_parse => FALSE);
  25. SYS.DBMS_OUTPUT.put_line ('Job Number is: ' || TO_CHAR (x));
  26. COMMIT;
  27. END;
  28. /
  30. -- 测试
  31. TRUNCATE TABLE t;
  32. EXEC dbms_job.run(101);
  34. SELECT * FROM t;
云推荐引擎

0 人点赞