Jobs running | ExpoDBA

Jobs running

Jobs running

alter session set nls_date_format='dd/mm/yyYY hh24:mi:ss';
set lines 100
set pages 150
col event for a30
	select /*+ rule*/ SCHEMA_USER, r.job, r.last_date, r.this_date, sysdate, s.sid, s.serial#, p.spid, status, s.event, s.seconds_in_wait
	, j.what
	from dba_jobs_running r, v$session s, dba_jobs j, v$process p, v$session_wait w
	where s.sid=r.sid
	and w.sid=s.sid
	and p.addr=s.paddr
	and j.job=r.job;