要 kill session 例子，session多，報錯如下

Process J000 died, see its trace file
Tue Sep 27 19:29:25 CST 2011
kkjcre1p: unable to spawn jobq slave process
Tue Sep 27 19:29:25 CST 2011
Errors in file /oracle/admin/hlsix/bdump/hlsix_cjq0_30221.trc:

Process J000 died, see its trace file
Mon Sep 26 09:24:14 CST 2011
kkjcre1p: unable to spawn jobq slave process
Mon Sep 26 09:24:14 CST 2011
Errors in file /oracle/admin/glmlb2/bdump/glmlb2_cjq0_14817.trc:

Process J000 died, see its trace file
Mon Sep 26 09:24:20 CST 2011
kkjcre1p: unable to spawn jobq slave process
Mon Sep 26 09:24:20 CST 2011
Errors in file /oracle/admin/glmlb2/bdump/glmlb2_cjq0_14817.trc:

Mon Sep 26 09:29:26 CST 2011
Process J000 died, see its trace file
Mon Sep 26 09:29:26 CST 2011
kkjcre1p: unable to spawn jobq slave process
Mon Sep 26 09:29:26 CST 2011
Errors in file /oracle/admin/glmlb2/bdump/glmlb2_cjq0_14817.trc:
Process J000 died, see its trace file
Mon Sep 26 09:24:14 CST 2011
kkjcre1p: unable to spawn jobq slave process
Mon Sep 26 09:24:14 CST 2011
Errors in file /oracle/admin/glmlb2/bdump/glmlb2_cjq0_14817.trc:

Process J000 died, see its trace file
Mon Sep 26 09:24:20 CST 2011
kkjcre1p: unable to spawn jobq slave process
Mon Sep 26 09:24:20 CST 2011
Errors in file /oracle/admin/glmlb2/bdump/glmlb2_cjq0_14817.trc:

Mon Sep 26 09:29:26 CST 2011
Process J000 died, see its trace file
Mon Sep 26 09:29:26 CST 2011
kkjcre1p: unable to spawn jobq slave process
Mon Sep 26 09:29:26 CST 2011
Errors in file /oracle/admin/glmlb2/bdump/glmlb2_cjq0_14817.trc:

trc檔案的記錄

*** SERVICE NAME:(SYS$BACKGROUND) 2011-09-22 21:38:20.164
*** SESSION ID:(2194.1) 2011-09-22 21:38:20.164
*** 2011-09-22 21:38:20.164
Process J000 is dead (pid=31197, state=3):
*** 2011-09-22 22:03:26.634
Process J000 is dead (pid=22103, state=3):
*** 2011-09-26 09:24:14.352
Process J000 is dead (pid=30252, state=3):
*** 2011-09-26 09:24:20.360
Process J000 is dead (pid=30313, state=3):
*** 2011-09-26 09:29:26.458
Process J000 is dead (pid=16178, state=3):
*** 2011-09-26 09:39:32.619
Process J000 is dead (pid=18131, state=3):
*** 2011-09-26 09:39:38.621
Process J000 is dead (pid=18177, state=3):
*** 2011-09-26 09:39:44.654
Process J001 is dead (pid=18555, state=3):
*** 2011-09-26 09:40:40.666
Process J001 is dead (pid=21786, state=3):

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23757700/viewspace-708390/，如需轉載，請註明出處，否則將追究法律責任。