Sign in or 
Share this
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 instnn format a12 hea "Instance(#)"
select slave_process_id
, session_id
, owner
, job_name
, instance_name||'('||instance_number||')' instnn
from dba_scheduler_running_jobs, gv$instance
where running_instance=instance_number;
PID ..SID ....Owner ..........Job Name ............Instance(#)
----- ------- --------------- -------------------- ------------
18 .. 120 ....SCOTT ..........AWXML$_281 ..........orcl(1)
30 ...124 ....SCOTT ..........AWXML$_281_590 ......orcl(1)
34 ...114 ....SCOTT ..........AWXML$_281_587 ......orcl(1)
37 ...127 ....SCOTT ..........AWXML$_281_591 ..... orcl(1)
38 ...134 ....SCOTT ..........AWXML$_281_585 ..... orcl(1)
39 ...122 ....SCOTT ..........AWXML$_281_588 ..... orcl(1)
40 ...115 ....SCOTT ..........AWXML$_281_592 ......orcl(1)
41 ...121 ....SCOTT ..........AWXML$_281_586 ......orcl(1)
42 ...111 ....SCOTT ..........AWXML$_281_589 ......orcl(1)
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 instnn format a12 hea "Instance(#)"
select slave_process_id
, session_id
, owner
, job_name
, instance_name||'('||instance_number||')' instnn
from dba_scheduler_running_jobs, gv$instance
where running_instance=instance_number;
PID ..SID ....Owner ..........Job Name ............Instance(#)
----- ------- --------------- -------------------- ------------
18 .. 120 ....SCOTT ..........AWXML$_281 ..........orcl(1)
30 ...124 ....SCOTT ..........AWXML$_281_590 ......orcl(1)
34 ...114 ....SCOTT ..........AWXML$_281_587 ......orcl(1)
37 ...127 ....SCOTT ..........AWXML$_281_591 ..... orcl(1)
38 ...134 ....SCOTT ..........AWXML$_281_585 ..... orcl(1)
39 ...122 ....SCOTT ..........AWXML$_281_588 ..... orcl(1)
40 ...115 ....SCOTT ..........AWXML$_281_592 ......orcl(1)
41 ...121 ....SCOTT ..........AWXML$_281_586 ......orcl(1)
42 ...111 ....SCOTT ..........AWXML$_281_589 ......orcl(1)
olapdba |
Latest page update: made by olapdba
, Jul 9 2009, 1:55 PM EDT
(about this update
About This Update
Edited by olapdba
26 words added 21 words deleted view changes - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
