|
- select s.USERNAME, s.RESOURCE_CONSUMER_GROUP
- from v$session s where s.TERMINAL='pts/1';
-
- select * from dba_scheduler_job_classes;
-
- select * from dba_tab_privs tp where tp.GRANTEE='HR';
-
- grant execute on jobclass1 to hr;
-
- select d.RESOURCE_CONSUMER_GROUP
- from DBA_SCHEDULER_RUNNING_JOBS d
- where d.JOB_NAME='JOB74';
-
-
复制代码
- create table t05317_lw( a timestamp ) ;
- create or replace procedure proc05317_lw
- is
- begin
- insert into t05317_lw values(systimestamp);
- commit;
- end;
- 单个轻量级作业:
- begin
- dbms_scheduler.create_job(
- job_name => 'hr.job8',
- program_name=>'hr.program8',
- schedule_name=>'hr.schedule8',
- job_style=>'LIGHTWEIGHT');
- end;
-
- begin
- dbms_scheduler.enable('HR.JOB8');
- end;
- select * from hr.t05317_lw;
- truncate table hr.t05317_lw;
- 作业阵列轻量级作业:
- DECLARE
- newjob sys.job;
- newjobarr sys.job_array;
- BEGIN
- -- Create an array of JOB object types
- newjobarr := sys.job_array();
- -- Allocate sufficient space in the array
- newjobarr.extend(100);
- -- Add definitions for jobs
- FOR i IN 1..100 LOOP
- -- Create a JOB object type
- newjob := sys.job(job_name => 'HR.JOB8_' || to_char(i),
- job_style => 'LIGHTWEIGHT',
- job_template => 'HR.PROGRAM8',
- enabled => TRUE );
- -- Add job to the array
- newjobarr(i) := newjob;
- END LOOP;
- -- Call CREATE_JOBS to create jobs in one transaction
- DBMS_SCHEDULER.CREATE_JOBS(newjobarr, 'TRANSACTIONAL');
- END;
- SQL> select count(*) from t05317_lw;
- COUNT(*)
- ----------
- 100
- SQL> select max(a) - min(a) from t05317_lw;
- MAX(A)-MIN(A)
- ---------------------------------------------------------------------------
- +000000000 00:00:00.391863
- truncate table hr.t05317_lw;
- DECLARE
- newjob sys.job;
- newjobarr sys.job_array;
- BEGIN
- -- Create an array of JOB object types
- newjobarr := sys.job_array();
- -- Allocate sufficient space in the array
- newjobarr.extend(100);
- -- Add definitions for jobs
- FOR i IN 1..100 LOOP
- -- Create a JOB object type
- newjob := sys.job(job_name => 'HR.JOB80_' || to_char(i),
- job_style => 'REGULAR',
- job_template => 'HR.PROGRAM8',
- enabled => TRUE );
- -- Add job to the array
- newjobarr(i) := newjob;
- END LOOP;
- -- Call CREATE_JOBS to create jobs in one transaction
- DBMS_SCHEDULER.CREATE_JOBS(newjobarr, 'TRANSACTIONAL');
- END;
-
-
-
复制代码
|
|