A Wetpaint Site

Sign in to Wetpaint

Sign in or

Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager)

Page Versions
To-Dos

Key: additions deletions

Showing 5 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Jul 9 2009, 1:55 PM EDT	olapdba		edit	26 words added 21 words deleted
Change: select slave_process_idselect, slave_process_id,session_id, session_id,owner, owner,job_name, job_name,instance_name\|\|'('\|\|instance_number\|\|')' instance_nameinstnnfrom 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) View changes from previous version. (Word count: 164)
	Jan 14 2008, 1:05 PM EST	olapdba		edit	2 words added 2 words deleted
Change: ...................Job Name .........................Instance----- ------- --------------- -------------------- ----------18 .. 120 ....SCOTT ..........AWXML$_281 ..........orcl30 ...124 ....SCOTT ..........AWXML$_281_590 ......orcl34 ...114 ....SCOTT ..........AWXML$_281_587 ......orcl37 ...127 ....SCOTT ..........AWXML$_281_591 ..... orcl38 ... View changes from previous version. (Word count: 153)
	Jan 14 2008, 9:35 AM EST	olapdba		edit	66 words added 18 words deleted
Change: 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 View changes from previous version. (Word count: 153)
	Jan 14 2008, 9:26 AM EST	olapdba		edit	138 words added
Change: 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_namefrom dba_scheduler_running_jobs, v$instance where running_instance=instance_number;PID ..SID ....Owner .........Job Name ...........Instance----- ------- --------------- -------------------- ----------18 .. 120 ....SCOTT ..........AWXML$_281 .........orcl30 ... View changes from previous version. (Word count: 104)
	Jan 14 2008, 9:21 AM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Jan 14 2008, 9:21 AM EST for: no reason given

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home