1 bug:
from catjobq.sql 9i:
create or replace view DBA_JOBS_RUNNING as
select v.SID, v.id2 JOB, j.FAILURES,
LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,
THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,
j.field1 INSTANCE
from sys.job$ j, v$lock v
where v.type = 'JQ' and j.job (+)= v.id2
/
tuning:
create or replace view sys.dba_jobs_running as
select /*+ use_hash(j,v) no_merge(v)*/ v.SID, v.id2 JOB, j.FAILURES,
LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,
THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,
j.field1 INSTANCE
from sys.job$ j, v$lock v
where v.type = 'JQ' and j.job (+)= v.id2;
select /*+ use_hash(j,v) no_merge(v)*/ v.SID, v.id2 JOB, j.FAILURES,
LAST_DATE, substr(to_char(last_date,'HH24:MI:SS'),1,8) LAST_SEC,
THIS_DATE, substr(to_char(this_date,'HH24:MI:SS'),1,8) THIS_SEC,
j.field1 INSTANCE
from sys.job$ j, v$lock v
where v.type = 'JQ' and j.job (+)= v.id2;
and then select dba_jobs_runing:
SQL> desc dba_jobs_running;
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
JOB NUMBER
FAILURES NUMBER
LAST_DATE DATE
LAST_SEC VARCHAR2(32)
THIS_DATE DATE
THIS_SEC VARCHAR2(32)
INSTANCE NUMBER
SQL> select sid,job from dba_jobs_running;
SID JOB
---------- ----------
126 322
alter system kill session;
然后再去停止job,否则直接停止job可能不成功。
停止job即可。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-765460/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13750068/viewspace-765460/