Bo's Oracle Station

查看: 1705|回复: 0

课程第46次(2017-10-19星期四)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-10-19 19:51:44 | 显示全部楼层 |阅读模式
Screenshot.png

Screenshot-2.png

Screenshot.png

  1. select s.USERNAME, s.RESOURCE_CONSUMER_GROUP
  2.   from v$session s  where s.TERMINAL='pts/1';
  3.   
  4. select   * from dba_scheduler_job_classes;

  5. select  * from dba_tab_privs tp where tp.GRANTEE='HR';
  6.   
  7. grant execute on jobclass1 to hr;

  8. select d.RESOURCE_CONSUMER_GROUP
  9.   from DBA_SCHEDULER_RUNNING_JOBS  d
  10.   where d.JOB_NAME='JOB74';
  11.   
  12.   
复制代码

  1. create table t05317_lw( a timestamp ) ;

  2. create or replace procedure proc05317_lw
  3. is
  4. begin
  5.    insert into  t05317_lw values(systimestamp);
  6.    commit;
  7. end;


  8. 单个轻量级作业:
  9. begin
  10.    dbms_scheduler.create_job(
  11.    job_name => 'hr.job8',
  12.    program_name=>'hr.program8',
  13.    schedule_name=>'hr.schedule8',
  14.    job_style=>'LIGHTWEIGHT');
  15. end;

  16. begin
  17.    dbms_scheduler.enable('HR.JOB8');
  18. end;

  19. select  * from hr.t05317_lw;

  20. truncate table hr.t05317_lw;


  21. 作业阵列轻量级作业:
  22. DECLARE
  23. newjob sys.job;
  24. newjobarr sys.job_array;
  25. BEGIN
  26. -- Create an array of JOB object types
  27.   newjobarr := sys.job_array();
  28. -- Allocate sufficient space in the array
  29.   newjobarr.extend(100);
  30. -- Add definitions for jobs
  31. FOR i IN 1..100 LOOP
  32.    -- Create a JOB object type
  33.    newjob := sys.job(job_name => 'HR.JOB8_' || to_char(i),
  34.                      job_style => 'LIGHTWEIGHT',
  35.                      job_template => 'HR.PROGRAM8',
  36.                    enabled => TRUE );
  37. -- Add job to the array
  38.    newjobarr(i) := newjob;
  39. END LOOP;
  40. -- Call CREATE_JOBS to create jobs in one transaction
  41. DBMS_SCHEDULER.CREATE_JOBS(newjobarr, 'TRANSACTIONAL');
  42. END;

  43. SQL> select count(*) from t05317_lw;

  44.   COUNT(*)
  45. ----------
  46.        100

  47. SQL> select max(a) - min(a) from t05317_lw;

  48. MAX(A)-MIN(A)
  49. ---------------------------------------------------------------------------
  50. +000000000 00:00:00.391863


  51. truncate table hr.t05317_lw;


  52. DECLARE
  53. newjob sys.job;
  54. newjobarr sys.job_array;
  55. BEGIN
  56. -- Create an array of JOB object types
  57.   newjobarr := sys.job_array();
  58. -- Allocate sufficient space in the array
  59.   newjobarr.extend(100);
  60. -- Add definitions for jobs
  61. FOR i IN 1..100 LOOP
  62.    -- Create a JOB object type
  63.    newjob := sys.job(job_name => 'HR.JOB80_' || to_char(i),
  64.                      job_style => 'REGULAR',
  65.                      job_template => 'HR.PROGRAM8',
  66.                    enabled => TRUE );
  67. -- Add job to the array
  68.    newjobarr(i) := newjob;
  69. END LOOP;
  70. -- Call CREATE_JOBS to create jobs in one transaction
  71. DBMS_SCHEDULER.CREATE_JOBS(newjobarr, 'TRANSACTIONAL');
  72. END;



复制代码


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 06:14 , Processed in 0.036018 second(s), 27 queries .

快速回复 返回顶部 返回列表