Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager)
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_name format a10 hea "Instance"
select slave_process_id, session_id, owner, job_name, instance_name
from dba_scheduler_running_jobs, v$instance where running_instance=instance_number;
PID ..SID ....Owner ..........Job Name ............Instance
----- ------- --------------- -------------------- ----------
18 .. 120 ....SCOTT ..........AWXML$_281 ..........orcl
30 ...124 ....SCOTT ..........AWXML$_281_590 ......orcl
34 ...114 ....SCOTT ..........AWXML$_281_587 ......orcl
37 ...127 ....SCOTT ..........AWXML$_281_591 ..... orcl
38 ...134 ....SCOTT ..........AWXML$_281_585 ..... orcl
39 ...122 ....SCOTT ..........AWXML$_281_588 ..... orcl
40 ...115 ....SCOTT ..........AWXML$_281_592 ......orcl
41 ...121 ....SCOTT ..........AWXML$_281_586 ......orcl
42 ...111 ....SCOTT ..........AWXML$_281_589 ......orcl
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_name format a10 hea "Instance"
select slave_process_id, session_id, owner, job_name, instance_name
from dba_scheduler_running_jobs, v$instance where running_instance=instance_number;
PID ..SID ....Owner ..........Job Name ............Instance
----- ------- --------------- -------------------- ----------
18 .. 120 ....SCOTT ..........AWXML$_281 ..........orcl
30 ...124 ....SCOTT ..........AWXML$_281_590 ......orcl
34 ...114 ....SCOTT ..........AWXML$_281_587 ......orcl
37 ...127 ....SCOTT ..........AWXML$_281_591 ..... orcl
38 ...134 ....SCOTT ..........AWXML$_281_585 ..... orcl
39 ...122 ....SCOTT ..........AWXML$_281_588 ..... orcl
40 ...115 ....SCOTT ..........AWXML$_281_592 ......orcl
41 ...121 ....SCOTT ..........AWXML$_281_586 ......orcl
42 ...111 ....SCOTT ..........AWXML$_281_589 ......orcl
Latest page update: made by olapdba
, Jan 14 2008, 1:05 PM EST
(about this update
About This Update
Edited by olapdba
2 words added
2 words deleted
view changes
- complete history)
Edited by olapdba
2 words added
2 words deleted
view changes
- complete history)
Keyword tags:
None
More Info: links to this page
