 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Job Classes
select
consumer_group
from
dba_rsrc_consumer_groups
;
CONSUMER_GROUP
------------------------------
OTHER_GROUPS
DEFAULT_CONSUMER_GROUP
SYS_GROUP
LOW_GROUP
AUTO_TASK_CONSUMER_GROUP
5 rows selected.
With this information a new job class can be
defined as follows:
BEGIN
DBMS_SCHEDULER.create_job_class (
job_class_name =>
'test_job_class',
resource_consumer_group =>
'default_consumer_group');
END;
/
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
