Version User Scope of changes
Jul 9 2009, 1:55 PM EDT (current) olapdba 26 words added, 21 words deleted
Jan 14 2008, 1:05 PM EST olapdba 2 words added, 2 words deleted

Changes

Key:  Additions   Deletions
When you make "parallel" submissions in AWM to allow concurrent job submissions (limited by the number of partitions e.g. 12 months when partitioned by month would allow up to 12 jobs) make sure you have enough job_queue_processes if you would like them to run at the same time.

col slave_process_id format 9999 hea "PID"
col session_id format 999999 hea "SID"
col owner format a15 hea "Owner"
col job_name format a20 hea "Job Name"
col instance_nameinstnn format a10a12 hea "Instance""Instance(#)"

select slave_process_id
select, slave_process_id,session_id
, session_id,owner
, owner,job_name
, job_name,instance_name||'('||instance_number||')' instance_nameinstnn
from dba_scheduler_running_jobs, v$instancegv$instance
where running_instance=instance_number;

PID ..SID ....Owner ..........Job Name ............InstanceInstance(#)
----- ------- --------------- -------------------- ----------------------
18 .. 120 ....SCOTT ..........AWXML$_281 ..........orclorcl(1)
30 ...124 ....SCOTT ..........AWXML$_281_590 ......orclorcl(1)
34 ...114 ....SCOTT ..........AWXML$_281_587 ......orclorcl(1)
37 ...127 ....SCOTT ..........AWXML$_281_591 ..... orclorcl(1)
38 ...134 ....SCOTT ..........AWXML$_281_585 ..... orclorcl(1)
39 ...122 ....SCOTT ..........AWXML$_281_588 ..... orclorcl(1)
40 ...115 ....SCOTT ..........AWXML$_281_592 ......orclorcl(1)
41 ...121 ....SCOTT ..........AWXML$_281_586 ......orclorcl(1)
42 ...111 ....SCOTT ..........AWXML$_281_589 ......orclorcl(1)