C:\Documents and Settings\abc>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 11 22:56:20 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect test/test
Connected.
SQL>
SQL> show parameter job
NAME TYPE VALUE
------------------------------------ ----------- --------------------
job_queue_processes integer 10
SQL> alter system set job_queue_processes =2
此时不论我们有多少个达到执行条件的JOB,也只能看到两个在运行
好象系统并未显示出那些未能执行的JOB,是什么原因造成的。
23:23:37 SQL> select job, last_date, this_date, next_date, what from dba_jobs;
JOB LAST_DATE THIS_DATE NEXT_DATE WHAT
---------- --------------- --------------- --------------- --------------------
3 071011 23:11:16 071011 23:21:16 mysleep10();
4 071011 23:15:56 071011 23:25:56 mysleep10();
5 071011 23:16:33 071011 23:26:33 mysleep10();
6 071011 23:17:59 071011 23:27:59 mysleep10();
7 071011 23:20:02 071011 23:30:02 mysleep10();
8 071011 23:19:42 071011 23:29:42 mysleep10();
9 071011 23:21:46 071011 23:20:04 mysleep10();
10 071011 23:22:05 071011 23:20:05 mysleep10();
11 071011 23:20:08 mysleep10();
9 rows selected.
23:23:41 SQL> select * from v$lock where sid >5;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
672B3D60 672B3D70 16 JQ 0 10 6 0 107 0
672B3DAC 672B3DBC 18 JQ 0 11 6 0 4 0
23:23:54 SQL> select * from dba_jobs_running;
SID JOB FAILURES LAST_DATE LAST_SEC THIS_DATE THIS_SEC
---------- ---------- ---------- --------------- ---------------- --------------- ---------------
16 10 071011 23:22:05 23:22:05
18 11 071011 23:23:49 23:23:49
[/COLOR]
[/FONT]