 |
IDS Forum
many threads for process ?
Posted By: Floyd Wellershaus
Date: Friday, 4 February 2005, at 7:53 a.m.
We are running a batch process, and when monitoring it, I see a huge amount of threads associated with it, and most of them are waiting. One of the tables in the query is fragmented, but it only has 10 fragments, so I wouldn't expect to see more than 10 scan threads.
Any ideas ?
below is an onstat -g ses for the session ( 265)and an onstat -g wai
Thanks.
IBM Informix Dynamic Server Version 9.40.FC3 -- On-Line -- Up 01:27:12 -- 2291184 Kbytes
session #RSAM total used dynamic
id user tty pid hostname threads memory memory explain
265 sentrycf - 602224 grace 136 9986048 9969864 off
tid name rstcb flags curstk status
409 sqlexec 700000060404b60 ---P--- 3648 sleeping(secs: 3)
421 group_1. 7000000604063d8 Y------ 1392 cond wait(await_MC1)
422 scan_2.0 700000060406c00 Y------ 1392 cond wait(await_MC2)
423 scan_3.0 700000061f33028 Y------ 1392 cond wait(await_MC3)
427 scan_5.0 700000061f33850 Y------ 1392 cond wait(await_MC5)
428 scan_5.1 700000061f34078 Y------ 1392 cond wait(await_MC5)
429 scan_5.2 700000061f348a0 Y------ 1392 cond wait(await_MC5)
430 scan_5.3 700000061f350c8 Y------ 1392 cond wait(await_MC5)
431 scan_5.4 700000061f358f0 Y------ 1392 cond wait(await_MC5)
432 scan_5.5 700000061f36118 Y------ 1392 cond wait(await_MC5)
433 scan_5.6 700000061f36940 Y------ 1392 cond wait(await_MC5)
434 scan_5.7 700000061f37168 Y------ 1392 cond wait(await_MC5)
435 scan_5.8 700000061f37990 Y------ 1392 cond wait(await_MC5)
436 scan_5.9 700000061f381b8 Y------ 1392 cond wait(await_MC5)
444 scan_6.0 700000061f39208 Y------ 1392 cond wait(await_MC6)
445 psortpro 700000061f39a30 Y------ 1488 cond wait(backend:0)
446 psortpro 700000061f3a258 Y------ 1488 cond wait(backend:1)
447 scan_7.0 700000061f3aa80 Y------ 1392 cond wait(await_MC7)
448 join_8.0 700000061f3b2a8 Y------ 1392 cond wait(await_MC8)
449 join_8.1 700000061f3bad0 Y------ 1392 cond wait(await_MC8)
450 scan_9.0 700000061f3c2f8 Y------ 1392 cond wait(await_MC9)
451 scan_9.1 700000061f3cb20 Y------ 1392 cond wait(await_MC9)
452 scan_9.2 700000061f3d348 Y------ 1392 cond wait(await_MC9)
453 scan_9.3 700000061f3db70 Y------ 1392 cond wait(await_MC9)
454 scan_9.4 700000061f3e398 Y------ 1392 cond wait(await_MC9)
455 scan_9.5 700000061f3ebc0 Y------ 1392 cond wait(await_MC9)
456 scan_9.6 700000061f3f3e8 Y------ 1392 cond wait(await_MC9)
457 scan_9.7 700000061f3fc10 Y------ 1392 cond wait(await_MC9)
458 scan_9.8 700000061f40438 Y------ 1392 cond wait(await_MC9)
459 scan_9.9 700000061f40c60 Y------ 1392 cond wait(await_MC9)
460 join_10. 700000061f41488 ------- 2000 sleeping(secs: 3)
461 join_10. 700000061f41cb0 ------- 2000 sleeping(secs: 3)
462 scan_11. 700000061f424d8 B---R-- 6272 sleeping(Forever)
463 join_12. 700000061f42d00 Y------ 1392 cond wait(await_MC12)
464 join_12. 700000061f43528 Y------ 1392 cond wait(await_MC12)
465 join_13. 700000061f43d50 Y------ 1392 cond wait(await_MC13)
466 join_13. 700000061f44578 Y------ 1392 cond wait(await_MC13)
467 join_14. 700000061f44da0 Y------ 1392 cond wait(await_MC14)
468 join_14. 700000061f455c8 Y------ 1392 cond wait(await_MC14)
469 scan_15. 700000061f45df0 Y------ 1392 cond wait(await_MC15)
470 scan_16. 700000061f46618 Y------ 1392 cond wait(await_MC16)
471 scan_17. 700000061f46e40 Y------ 1392 cond wait(await_MC17)
472 scan_18. 700000061f47668 Y------ 1392 cond wait(await_MC18)
473 scan_19. 700000061f47e90 Y------ 1392 cond wait(await_MC19)
474 scan_20. 700000061f486b8 Y------ 1392 cond wait(await_MC20)
475 scan_21. 700000061f48ee0 Y------ 1392 cond wait(await_MC21)
476 scan_22. 700000061f49708 Y------ 1392 cond wait(await_MC22)
477 scan_23. 700000061f49f30 Y------ 1392 cond wait(await_MC23)
478 scan_24. 700000061f4a758 Y------ 1392 cond wait(await_MC24)
479 scan_25. 700000061f4af80 Y------ 1392 cond wait(await_MC25)
480 scan_26. 700000061f4b7a8 Y------ 1392 cond wait(await_MC26)
481 scan_27. 700000061f4bfd0 Y------ 1392 cond wait(await_MC27)
482 scan_28. 700000061f4c7f8 Y------ 1392 cond wait(await_MC28)
483 scan_29. 700000061f4d020 Y------ 1392 cond wait(await_MC29)
484 scan_30. 700000061f4d848 Y------ 1392 cond wait(await_MC30)
485 scan_31. 700000061f4e070 Y------ 1392 cond wait(await_MC31)
486 scan_32. 700000061f4e898 Y------ 1392 cond wait(await_MC32)
487 scan_33. 700000061f4f0c0 Y------ 1392 cond wait(await_MC33)
488 scan_34. 700000061f4f8e8 Y------ 1392 cond wait(await_MC34)
489 scan_35. 700000061f50110 Y------ 1392 cond wait(await_MC35)
490 scan_36. 700000061f50938 Y------ 1392 cond wait(await_MC36)
491 scan_37. 700000061f51160 Y------ 1392 cond wait(await_MC37)
492 scan_38. 700000061f51988 Y------ 1392 cond wait(await_MC38)
494 scan_39. 700000061f529d8 Y------ 1392 cond wait(await_MC39)
495 scan_40. 700000061f53200 Y------ 1392 cond wait(await_MC40)
496 scan_41. 700000061f53a28 Y------ 1392 cond wait(await_MC41)
497 scan_42. 700000061f54250 Y------ 1392 cond wait(await_MC42)
498 scan_43. 700000061f54a78 Y------ 1392 cond wait(await_MC43)
499 scan_44. 700000061f552a0 Y------ 1392 cond wait(await_MC44)
500 scan_45. 700000061f55ac8 Y------ 1392 cond wait(await_MC45)
501 scan_46. 700000061f562f0 Y------ 1392 cond wait(await_MC46)
502 scan_47. 700000061f56b18 Y------ 1392 cond wait(await_MC47)
503 scan_48. 700000061f57340 Y------ 1392 cond wait(await_MC48)
504 scan_49. 700000061f57b68 Y------ 1392 cond wait(await_MC49)
505 scan_50. 700000061f58390 Y------ 1392 cond wait(await_MC50)
506 scan_51. 700000061f58bb8 Y------ 1392 cond wait(await_MC51)
507 scan_52. 700000061f593e0 Y------ 1392 cond wait(await_MC52)
508 scan_53. 700000061f59c08 Y------ 1392 cond wait(await_MC53)
509 scan_54. 700000061f5a430 Y------ 1392 cond wait(await_MC54)
510 scan_55. 700000061f5ac58 Y------ 1392 cond wait(await_MC55)
511 scan_56. 700000061f5b480 Y------ 1392 cond wait(await_MC56)
512 scan_57. 700000061f5bca8 Y------ 1392 cond wait(await_MC57)
513 scan_58. 700000061f5c4d0 Y------ 1392 cond wait(await_MC58)
514 scan_59. 700000061f5ccf8 Y------ 1392 cond wait(await_MC59)
515 scan_60. 700000061f5d520 Y------ 1392 cond wait(await_MC60)
516 scan_61. 700000061f5dd48 Y------ 1392 cond wait(await_MC61)
517 scan_62. 700000061f5e570 Y------ 1392 cond wait(await_MC62)
518 scan_63. 700000061f5ed98 Y------ 1392 cond wait(await_MC63)
519 scan_64. 700000061f5f5c0 Y------ 1392 cond wait(await_MC64)
520 scan_65. 700000061f5fde8 Y------ 1392 cond wait(await_MC65)
521 scan_66. 700000061f521b0 Y------ 1392 cond wait(await_MC66)
522 scan_67. 700000061f60610 Y------ 1392 cond wait(await_MC67)
523 scan_68. 700000061f60e38 Y------ 1392 cond wait(await_MC68)
524 scan_69. 700000061f61660 Y------ 1392 cond wait(await_MC69)
525 scan_70. 700000061f61e88 Y------ 1392 cond wait(await_MC70)
526 scan_71. 700000061f626b0 Y------ 1392 cond wait(await_MC71)
527 scan_72. 700000061f62ed8 Y------ 1392 cond wait(await_MC72)
528 scan_73. 700000061f63700 Y------ 1392 cond wait(await_MC73)
529 scan_74. 700000061f63f28 Y------ 1392 cond wait(await_MC74)
530 scan_75. 700000061f64750 Y------ 1392 cond wait(await_MC75)
531 scan_76. 700000061f64f78 Y------ 1392 cond wait(await_MC76)
532 scan_77. 700000061f657a0 Y------ 1392 cond wait(await_MC77)
533 scan_78. 700000061f65fc8 Y------ 1392 cond wait(await_MC78)
534 scan_79. 700000061f667f0 Y------ 1392 cond wait(await_MC79)
535 scan_80. 700000061f67018 Y------ 1392 cond wait(await_MC80)
536 scan_81. 700000061f67840 Y------ 1392 cond wait(await_MC81)
537 scan_82. 700000061f68068 Y------ 1392 cond wait(await_MC82)
538 scan_83. 700000061f68890 Y------ 1392 cond wait(await_MC83)
539 scan_84. 700000061f690b8 Y------ 1392 cond wait(await_MC84)
540 scan_85. 700000061f698e0 Y------ 1392 cond wait(await_MC85)
541 scan_86. 700000061f6a108 Y------ 1392 cond wait(await_MC86)
542 scan_87. 700000061f6a930 Y------ 1392 cond wait(await_MC87)
543 scan_88. 700000061f6b158 Y------ 1392 cond wait(await_MC88)
544 scan_89. 700000061f6b980 Y------ 1392 cond wait(await_MC89)
545 scan_90. 700000061f6c1a8 Y------ 1392 cond wait(await_MC90)
546 scan_91. 700000061f6c9d0 Y------ 1392 cond wait(await_MC91)
547 scan_92. 700000061f6d1f8 Y------ 1392 cond wait(await_MC92)
548 scan_93. 700000061f6da20 Y------ 1392 cond wait(await_MC93)
549 scan_94. 700000061f6e248 Y------ 1392 cond wait(await_MC94)
550 scan_95. 700000061f6ea70 Y------ 1392 cond wait(await_MC95)
551 scan_96. 700000061f6f298 Y------ 1392 cond wait(await_MC96)
552 scan_97. 700000061f6fac0 Y------ 1392 cond wait(await_MC97)
553 scan_98. 700000061f702e8 Y------ 1392 cond wait(await_MC98)
554 scan_99. 700000061f70b10 Y------ 1392 cond wait(await_MC99)
555 scan_100 700000061f71338 Y------ 1392 cond wait(await_MC100)
556 scan_101 700000061f71b60 Y------ 1392 cond wait(await_MC101)
557 scan_102 700000061f72388 Y------ 1392 cond wait(await_MC102)
558 scan_103 700000061f72bb0 Y------ 1392 cond wait(await_MC103)
559 scan_104 700000061f733d8 Y------ 1392 cond wait(await_MC104)
560 scan_105 700000061f73c00 Y------ 1392 cond wait(await_MC105)
561 scan_106 700000065515028 Y------ 1392 cond wait(await_MC106)
562 scan_107 700000065515850 Y------ 1392 cond wait(await_MC107)
563 scan_108 700000065516078 Y------ 1392 cond wait(await_MC108)
564 scan_109 7000000655168a0 Y------ 1392 cond wait(await_MC109)
568 scan_110 700000065518118 Y------ 1392 cond wait(await_MC110)
569 scan_111 700000065518940 Y------ 1392 cond wait(await_MC111)
Memory pools count 3
name class addr totalsize freesize #allocfrag #freefrag
265 V 70000006198c040 9728000 1888 18357 4
265_SORT_0 V 700000062a25040 204800 7264 469 54
name free used name free used
overhead 0 6496 mtmisc 0 10176
resident 0 15704 scb 0 15808
opentable 0 1357032 filetable 0 237312
ru 0 280 misc 0 136
blobio 0 9192 log 0 575552
temprec 0 149904 keys 0 22344
ralloc 0 5216824 gentcb 0 88096
ostcb 0 3448 sort 0 19752
sqscb 0 241168 sql 0 72
srtmembuf 0 146816 rdahead 0 106072
xchg_desc 0 146576 xchg_port 0 127664
xchg_packet 0 61528 xchg_group 0 11600
xchg_priv 0 13160 hashfiletab 0 75072
osenv 0 3416 sqtcb 0 491920
fragman 0 692904 shmblklist 0 58576
sapi 0 64 udr 0 2160
sqlj 0 72
sqscb info
scb sqscb optofc pdqpriority sqlstats optcompind directives
7000000614480b0 70000006234e028 0 20 0 0 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
265 SELECT sentryprod NL Wait 0 0 9.03 Off
Current SQL statement :
SELECT h.stprofil_token,
h.scsublog_token,
h.s_token,
h.term_beg_dt,
h.term_end_dt,
h.rpt_sublog_token,
h.rpt_token,
h.rec_type,
d.ssn,
d.first_name,
d.initial,
d.last_name,
d.suffix,
d.birth_dt,
d.enroll_status,
d.status_start_dt,
d.pre_ch_status_flag,
d.grad_dt,
d.dir_block_ind,
d.source_flag,
d.prev_name,
d.prev_ssn,
d.ssd_derived,
a.street1,
a.street2,
a.city,
a.state,
a.zip,
a.country,
s.scprofil_token,
s.certification_dt
FROM stsubhst h, stsubdtl d, stsubaddr a, scsublog s
WHERE h.scsublog_token = ? AND h.s_token = ?
AND d.token = h.stsubdtl_token
AND a.token = h.stsubaddr_token
AND s.token = h.scsublog_token
Last parsed SQL statement :
INSERT INTO mbresp_509 (notification_type, scsublog_token,
stprofil_token, __sublog_token, __token, s_token, resp_status, ssn,
first_name, initial, last_name, name_suffix,street1, street2, city,
state, zip, country, enroll_status, status_start_dt,
pre_ch_status_flag, schl_code, schl_branch, grad_dt, certification_dt,
term_beg_dt, term_end_dt, prev_last_name, prev_ssn, ssn_chg_flag,
name_chg_flag, address_chg_flag, enr_stat_chg_flag, enroll_dt_chg_flag,
school_chg_flag, grad_dt_chg_flag, term_dt_chg_flag,
cert_dt_chg_flag, paper_cert_flag) VALUES (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)
================ONSTAT -G WAI
IBM Informix Dynamic Server Version 9.40.FC3 -- On-Line -- Up 01:23:19 -- 2291184 Kbytes
Waiting threads:
tid tcb rstcb prty status vp-class name
2 700000060d6f1f8 0 2 sleeping forever 8lio lio vp 0
3 700000060da81f8 0 2 sleeping forever 9pio pio vp 0
4 700000060dc81f8 0 2 sleeping forever 10aio aio vp 0
5 700000060de81f8 0 2 sleeping forever 11msc msc vp 0
6 700000060e201f8 0 2 sleeping forever 12aio aio vp 1
7 700000060e401f8 0 2 sleeping forever 13aio aio vp 2
8 700000060e601f8 0 2 sleeping forever 14aio aio vp 3
9 700000060e801f8 0 2 sleeping forever 15aio aio vp 4
10 700000060ea01f8 0 2 sleeping forever 16aio aio vp 5
11 700000060ec0418 7000000603c6028 4 sleeping secs: 1 1cpu main_loop()
14 700000060efdd88 0 3 sleeping forever 1cpu sm_listen
15 700000060da85b0 0 2 sleeping secs: 1 4cpu sm_discon
16 700000060dc8748 0 3 sleeping forever 1cpu soctcplst
17 700000060d74b68 0 3 sleeping forever 3cpu soctcplst
18 700000060d7a4a0 7000000603c6850 2 sleeping forever 5cpu flush_sub(0)
19 700000060d7a740 7000000603c7078 2 sleeping forever 7cpu flush_sub(1)
20 700000060d7aa48 7000000603c78a0 2 sleeping forever 3cpu flush_sub(2)
21 700000060d7ad50 7000000603c80c8 2 sleeping forever 3cpu flush_sub(3)
22 700000060d7f238 7000000603c88f0 2 sleeping forever 6cpu flush_sub(4)
23 700000060d7f540 7000000603c9118 2 sleeping forever 5cpu flush_sub(5)
24 700000060d7f848 7000000603c9940 2 sleeping forever 1cpu flush_sub(6)
25 700000060d7fb50 7000000603ca168 2 sleeping forever 1cpu flush_sub(7)
26 700000060fe4028 7000000603ca990 2 sleeping forever 1cpu flush_sub(8)
27 700000060fe4330 7000000603cb1b8 2 sleeping forever 1cpu flush_sub(9)
28 700000060fe4638 7000000603cb9e0 2 sleeping forever 1cpu flush_sub(10)
29 700000060fe4940 7000000603cc208 2 sleeping forever 1cpu flush_sub(11)
30 700000060fe4c48 7000000603cca30 2 sleeping forever 1cpu flush_sub(12)
31 70000006103b028 7000000603cd258 2 sleeping forever 1cpu flush_sub(13)
32 70000006103b330 7000000603cda80 2 sleeping forever 1cpu flush_sub(14)
33 70000006103b638 7000000603ce2a8 2 sleeping forever 1cpu flush_sub(15)
34 70000006103b940 7000000603cead0 2 sleeping forever 1cpu flush_sub(16)
35 70000006103bc48 7000000603cf2f8 2 sleeping forever 1cpu flush_sub(17)
36 700000061092028 7000000603cfb20 2 sleeping forever 1cpu flush_sub(18)
37 700000061092330 7000000603d0348 2 sleeping forever 1cpu flush_sub(19)
38 700000061092638 7000000603d0b70 2 sleeping forever 1cpu flush_sub(20)
39 700000061092940 7000000603d1398 2 sleeping forever 1cpu flush_sub(21)
40 700000061092c48 7000000603d1bc0 2 sleeping forever 1cpu flush_sub(22)
41 7000000610e9028 7000000603d23e8 2 sleeping forever 1cpu flush_sub(23)
42 7000000610e9330 7000000603d2c10 2 sleeping forever 1cpu flush_sub(24)
43 7000000610e9638 7000000603d3438 2 sleeping forever 1cpu flush_sub(25)
44 7000000610e9940 7000000603d3c60 2 sleeping forever 1cpu flush_sub(26)
45 7000000610e9c48 7000000603d4488 2 sleeping forever 1cpu flush_sub(27)
46 700000061140028 7000000603d4cb0 2 sleeping forever 1cpu flush_sub(28)
47 700000061140330 7000000603d54d8 2 sleeping forever 1cpu flush_sub(29)
48 700000061140638 7000000603d5d00 2 sleeping forever 1cpu flush_sub(30)
49 700000061140940 7000000603d6528 2 sleeping forever 1cpu flush_sub(31)
50 700000061140c48 7000000603d6d50 2 sleeping forever 1cpu flush_sub(32)
51 700000061196028 7000000603d7578 2 sleeping forever 1cpu flush_sub(33)
52 700000061196330 7000000603d7da0 2 sleeping forever 1cpu flush_sub(34)
53 700000061196638 7000000603d85c8 2 sleeping forever 1cpu flush_sub(35)
54 700000061196940 7000000603d8df0 2 sleeping forever 1cpu flush_sub(36)
55 700000061196c48 7000000603d9618 2 sleeping forever 1cpu flush_sub(37)
56 7000000611ed028 7000000603d9e40 2 sleeping forever 1cpu flush_sub(38)
57 7000000611ed330 7000000603da668 2 sleeping forever 1cpu flush_sub(39)
58 7000000611ed638 7000000603dae90 2 sleeping forever 1cpu flush_sub(40)
59 7000000611ed940 7000000603db6b8 2 sleeping forever 1cpu flush_sub(41)
60 7000000611edc48 7000000603dbee0 2 sleeping forever 1cpu flush_sub(42)
61 700000061244028 7000000603dc708 2 sleeping forever 1cpu flush_sub(43)
62 700000061244330 7000000603dcf30 2 sleeping forever 1cpu flush_sub(44)
63 700000061244638 7000000603dd758 2 sleeping forever 1cpu flush_sub(45)
64 700000061244940 7000000603ddf80 2 sleeping forever 1cpu flush_sub(46)
65 700000061244c48 7000000603de7a8 2 sleeping forever 1cpu flush_sub(47)
66 70000006129c028 7000000603defd0 2 sleeping forever 1cpu flush_sub(48)
67 70000006129c330 7000000603df7f8 2 sleeping forever 1cpu flush_sub(49)
68 70000006129c638 7000000603e0020 2 sleeping forever 1cpu flush_sub(50)
69 70000006129c940 7000000603e0848 2 sleeping forever 1cpu flush_sub(51)
70 70000006129cc48 7000000603e1070 2 sleeping forever 1cpu flush_sub(52)
71 7000000612f3028 7000000603e1898 2 sleeping forever 1cpu flush_sub(53)
72 7000000612f3330 7000000603e20c0 2 sleeping forever 1cpu flush_sub(54)
73 7000000612f3638 7000000603e28e8 2 sleeping forever 1cpu flush_sub(55)
74 7000000612f3940 7000000603e3110 2 sleeping forever 1cpu flush_sub(56)
75 7000000612f3c48 7000000603e3938 2 sleeping forever 1cpu flush_sub(57)
76 70000006134a028 7000000603e4160 2 sleeping forever 1cpu flush_sub(58)
77 70000006134a330 7000000603e4988 2 sleeping forever 1cpu flush_sub(59)
78 70000006134a638 7000000603e51b0 2 sleeping forever 1cpu flush_sub(60)
79 70000006134a940 7000000603e59d8 2 sleeping forever 1cpu flush_sub(61)
80 70000006134ac48 7000000603e6200 2 sleeping forever 6cpu flush_sub(62)
81 7000000613a0028 7000000603e6a28 2 sleeping forever 5cpu flush_sub(63)
82 7000000613a0330 7000000603e7250 2 sleeping forever 6cpu flush_sub(64)
83 7000000613a0638 7000000603e7a78 2 sleeping forever 4cpu flush_sub(65)
84 7000000613a0940 7000000603e82a0 2 sleeping forever 6cpu flush_sub(66)
85 7000000613a0c48 7000000603e8ac8 2 sleeping forever 6cpu flush_sub(67)
86 7000000613f8028 7000000603e92f0 2 sleeping forever 1cpu flush_sub(68)
87 7000000613f8330 7000000603e9b18 2 sleeping forever 7cpu flush_sub(69)
88 7000000613f8638 7000000603ea340 2 sleeping forever 5cpu flush_sub(70)
89 7000000613f8940 7000000603eab68 2 sleeping forever 7cpu flush_sub(71)
90 7000000613f8c48 7000000603eb390 2 sleeping forever 6cpu flush_sub(72)
91 70000006144f028 7000000603ebbb8 2 sleeping forever 3cpu flush_sub(73)
92 70000006144f330 7000000603ec3e0 2 sleeping forever 3cpu flush_sub(74)
93 70000006144f638 7000000603ecc08 2 sleeping forever 6cpu flush_sub(75)
94 70000006144f940 7000000603ed430 2 sleeping forever 5cpu flush_sub(76)
95 70000006144fc48 7000000603edc58 2 sleeping forever 1cpu flush_sub(77)
96 7000000614a6028 7000000603ee480 2 sleeping forever 3cpu flush_sub(78)
97 7000000614a6330 7000000603eeca8 2 sleeping forever 7cpu flush_sub(79)
98 7000000614a6638 7000000603ef4d0 2 sleeping forever 3cpu flush_sub(80)
99 7000000614a6940 7000000603efcf8 2 sleeping forever 5cpu flush_sub(81)
100 7000000614a6c48 7000000603f0520 2 sleeping forever 3cpu flush_sub(82)
101 7000000614fd028 7000000603f0d48 2 sleeping forever 3cpu flush_sub(83)
102 7000000614fd330 7000000603f1570 2 sleeping forever 5cpu flush_sub(84)
103 7000000614fd638 7000000603f1d98 2 sleeping forever 4cpu flush_sub(85)
104 7000000614fd940 7000000603f25c0 2 sleeping forever 6cpu flush_sub(86)
105 7000000614fdc48 7000000603f2de8 2 sleeping forever 6cpu flush_sub(87)
106 700000061555028 7000000603f3610 2 sleeping forever 7cpu flush_sub(88)
107 700000061555330 7000000603f3e38 2 sleeping forever 7cpu flush_sub(89)
108 700000061555638 7000000603f4660 2 sleeping forever 7cpu flush_sub(90)
109 700000061555940 7000000603f4e88 2 sleeping forever 6cpu flush_sub(91)
110 700000061555c48 7000000603f56b0 2 sleeping forever 7cpu flush_sub(92)
111 7000000615ab028 7000000603f5ed8 2 sleeping forever 5cpu flush_sub(93)
112 7000000615ab330 7000000603f6700 2 sleeping forever 3cpu flush_sub(94)
113 7000000615ab638 7000000603f6f28 2 sleeping forever 3cpu flush_sub(95)
114 7000000615ab940 7000000603f7750 2 sleeping forever 3cpu flush_sub(96)
115 7000000615abc48 7000000603f7f78 2 sleeping forever 3cpu flush_sub(97)
116 700000061602028 7000000603f87a0 2 sleeping forever 7cpu flush_sub(98)
117 700000061602330 7000000603f8fc8 2 sleeping forever 1cpu flush_sub(99)
118 700000061602638 7000000603f97f0 2 sleeping forever 5cpu flush_sub(100)
119 700000061602940 7000000603fa018 2 sleeping forever 7cpu flush_sub(101)
120 700000061602c48 7000000603fa840 2 sleeping forever 4cpu flush_sub(102)
121 700000061659028 7000000603fb068 2 sleeping forever 6cpu flush_sub(103)
122 700000061659330 7000000603fb890 2 sleeping forever 4cpu flush_sub(104)
123 700000061659638 7000000603fc0b8 2 sleeping forever 5cpu flush_sub(105)
124 700000061659940 7000000603fc8e0 2 sleeping forever 4cpu flush_sub(106)
125 700000061659c48 7000000603fd108 2 sleeping forever 7cpu flush_sub(107)
126 7000000616b1028 7000000603fd930 2 sleeping forever 4cpu flush_sub(108)
127 7000000616b1330 7000000603fe158 2 sleeping forever 5cpu flush_sub(109)
128 7000000616b1638 7000000603fe980 2 sleeping forever 1cpu flush_sub(110)
129 7000000616b1940 7000000603ff1a8 2 sleeping forever 6cpu flush_sub(111)
130 7000000616b1c48 7000000603ff9d0 2 sleeping forever 4cpu flush_sub(112)
131 700000061708028 7000000604001f8 2 sleeping forever 3cpu flush_sub(113)
132 700000061708330 700000060400a20 2 sleeping forever 4cpu flush_sub(114)
133 700000061708638 700000060401248 2 sleeping forever 3cpu flush_sub(115)
134 700000061708940 700000060401a70 2 sleeping forever 5cpu flush_sub(116)
135 700000061708c48 700000060402298 2 sleeping forever 4cpu flush_sub(117)
136 70000006175f028 700000060402ac0 2 sleeping forever 6cpu flush_sub(118)
137 70000006175f330 7000000604032e8 2 sleeping forever 3cpu flush_sub(119)
138 70000006175f638 0 4 sleeping forever 1cpu kaio
139 70000006192a4f0 700000060403b10 3 sleeping forever 1cpu aslogflush
140 70000006195a028 700000060404338 1 sleeping secs: 155 7cpu btscanner 0
142 70000006195aca8 0 4 sleeping forever 3cpu kaio
157 700000061fd6920 0 4 sleeping forever 4cpu kaio
158 700000061fd6b40 700000060405bb0 4 sleeping secs: 1 1cpu onmode_mon
279 700000061c4fbc8 0 4 sleeping forever 5cpu kaio
280 700000062327a28 700000060405388 2 cond wait netnorm 3cpu sqlexec
409 700000062342028 700000060404b60 2 sleeping secs: 3 1cpu sqlexec
421 7000000623dc1b0 7000000604063d8 2 cond wait await_MC1 3cpu group_1.0
422 7000000623dc450 700000060406c00 2 cond wait await_MC2 3cpu scan_2.0
423 700000062484028 700000061f33028 2 cond wait await_MC3 4cpu scan_3.0
424 700000062484330 0 4 sleeping forever 6cpu kaio
425 7000000624845b8 0 4 sleeping forever 7cpu kaio
427 7000000624993d8 700000061f33850 2 cond wait await_MC5 3cpu scan_5.0
428 700000062499638 700000061f34078 2 cond wait await_MC5 3cpu scan_5.1
429 700000062499940 700000061f348a0 2 cond wait await_MC5 5cpu scan_5.2
430 700000062499c48 700000061f350c8 2 cond wait await_MC5 4cpu scan_5.3
431 70000006255e028 700000061f358f0 2 cond wait await_MC5 7cpu scan_5.4
432 70000006255e330 700000061f36118 2 cond wait await_MC5 4cpu scan_5.5
433 70000006255e638 700000061f36940 2 cond wait await_MC5 3cpu scan_5.6
434 70000006255e940 700000061f37168 2 cond wait await_MC5 4cpu scan_5.7
435 70000006255ec48 700000061f37990 2 cond wait await_MC5 4cpu scan_5.8
436 7000000625d3028 700000061f381b8 2 cond wait await_MC5 7cpu scan_5.9
444 7000000629e33c8 700000061f39208 2 cond wait await_MC6 3cpu scan_6.0
445 700000062a46660 700000061f39a30 2 cond wait backend:0 4cpu psortproc
446 700000062a46980 700000061f3a258 2 cond wait backend:1 3cpu psortproc
447 700000062a491b0 700000061f3aa80 2 cond wait await_MC7 3cpu scan_7.0
448 700000062a910a8 700000061f3b2a8 2 cond wait await_MC8 1cpu join_8.0
449 700000062a91330 700000061f3bad0 2 cond wait await_MC8 4cpu join_8.1
450 700000062a91bf8 700000061f3c2f8 2 cond wait await_MC9 4cpu scan_9.0
451 700000063a2a028 700000061f3cb20 2 cond wait await_MC9 3cpu scan_9.1
452 700000063a2a2f0 700000061f3d348 2 cond wait await_MC9 4cpu scan_9.2
453 700000063a2a5f8 700000061f3db70 2 cond wait await_MC9 6cpu scan_9.3
454 700000063a2a900 700000061f3e398 2 cond wait await_MC9 3cpu scan_9.4
455 700000063a2ac08 700000061f3ebc0 2 cond wait await_MC9 4cpu scan_9.5
456 700000063b2f028 700000061f3f3e8 2 cond wait await_MC9 1cpu scan_9.6
457 700000063b2f330 700000061f3fc10 2 cond wait await_MC9 3cpu scan_9.7
458 700000063b2f638 700000061f40438 2 cond wait await_MC9 4cpu scan_9.8
459 700000063b2f940 700000061f40c60 2 cond wait await_MC9 6cpu scan_9.9
461 70000006443d7d8 700000061f41cb0 2 cond wait await_MC10 1cpu join_10.1
462 70000006446d130 700000061f424d8 2 cond wait await_MC11 4cpu scan_11.0
463 7000000644c1340 700000061f42d00 2 cond wait await_MC12 3cpu join_12.0
464 7000000644c1608 700000061f43528 2 cond wait await_MC12 3cpu join_12.1
465 700000064501028 700000061f43d50 2 cond wait await_MC13 3cpu join_13.0
466 700000064501330 700000061f44578 2 cond wait await_MC13 3cpu join_13.1
467 700000064501c78 700000061f44da0 2 cond wait await_MC14 4cpu join_14.0
468 70000006453e028 700000061f455c8 2 cond wait await_MC14 4cpu join_14.1
469 70000006453e8e8 700000061f45df0 2 cond wait await_MC15 4cpu scan_15.0
470 700000062289028 700000061f46618 2 cond wait await_MC16 3cpu scan_16.0
471 700000062289d70 700000061f46e40 2 cond wait await_MC17 3cpu scan_17.0
472 700000061dad028 700000061f47668 2 cond wait await_MC18 3cpu scan_18.0
473 700000061ca81b0 700000061f47e90 2 cond wait await_MC19 3cpu scan_19.0
474 700000061d422b8 700000061f486b8 2 cond wait await_MC20 3cpu scan_20.0
475 70000006223f4d0 700000061f48ee0 2 cond wait await_MC21 4cpu scan_21.0
476 7000000619a4668 700000061f49708 2 cond wait await_MC22 1cpu scan_22.0
477 70000006229a888 700000061f49f30 2 cond wait await_MC23 4cpu scan_23.0
478 700000061e45a20 700000061f4a758 2 cond wait await_MC24 3cpu scan_24.0
479 7000000646b4cc8 700000061f4af80 2 cond wait await_MC25 3cpu scan_25.0
480 700000061f84028 700000061f4b7a8 2 cond wait await_MC26 3cpu scan_26.0
481 7000000622200a8 700000061f4bfd0 2 cond wait await_MC27 5cpu scan_27.0
482 700000061fcd230 700000061f4c7f8 2 cond wait await_MC28 3cpu scan_28.0
483 700000061dbb3c8 700000061f4d020 2 cond wait await_MC29 3cpu scan_29.0
484 700000061e625e0 700000061f4d848 2 cond wait await_MC30 6cpu scan_30.0
485 7000000619a7778 700000061f4e070 2 cond wait await_MC31 6cpu scan_31.0
486 700000062285998 700000061f4e898 2 cond wait await_MC32 4cpu scan_32.0
487 7000000647f9b30 700000061f4f0c0 2 cond wait await_MC33 4cpu scan_33.0
488 70000006481ed50 700000061f4f8e8 2 cond wait await_MC34 3cpu scan_34.0
489 700000061eaf028 700000061f50110 2 cond wait await_MC35 4cpu scan_35.0
490 700000061eafd28 700000061f50938 2 cond wait await_MC36 7cpu scan_36.0
491 700000062250028 700000061f51160 2 cond wait await_MC37 3cpu scan_37.0
492 700000062250cc0 700000061f51988 2 cond wait await_MC38 6cpu scan_38.0
494 700000061cf73c8 700000061f529d8 2 cond wait await_MC39 3cpu scan_39.0
495 700000061d14450 700000061f53200 2 cond wait await_MC40 3cpu scan_40.0
496 70000006204a668 700000061f53a28 2 cond wait await_MC41 3cpu scan_41.0
497 700000061985800 700000061f54250 2 cond wait await_MC42 4cpu scan_42.0
498 700000061e53910 700000061f54a78 2 cond wait await_MC43 3cpu scan_43.0
499 7000000646d4aa8 700000061f552a0 2 cond wait await_MC44 3cpu scan_44.0
500 70000006202c230 700000061f55ac8 2 cond wait await_MC45 7cpu scan_45.0
501 700000061f923c8 700000061f562f0 2 cond wait await_MC46 4cpu scan_46.0
502 700000061cd85e0 700000061f56b18 2 cond wait await_MC47 3cpu scan_47.0
503 7000000622aa778 700000061f57340 2 cond wait await_MC48 4cpu scan_48.0
504 7000000621c6998 700000061f57b68 2 cond wait await_MC49 7cpu scan_49.0
505 700000061cc9668 700000061f58390 2 cond wait await_MC50 6cpu scan_50.0
506 7000000620b4800 700000061f58bb8 2 cond wait await_MC51 6cpu scan_51.0
507 7000000621f3a20 700000061f593e0 2 cond wait await_MC52 7cpu scan_52.0
508 700000064b3dc40 700000061f59c08 2 cond wait await_MC53 6cpu scan_53.0
509 7000000619f5910 700000061f5a430 2 cond wait await_MC54 5cpu scan_54.0
510 700000062305028 700000061f5ac58 2 cond wait await_MC55 3cpu scan_55.0
511 700000062202130 700000061f5b480 2 cond wait await_MC56 5cpu scan_56.0
512 700000061eea340 700000061f5bca8 2 cond wait await_MC57 3cpu scan_57.0
513 700000061d7e558 700000061f5c4d0 2 cond wait await_MC58 3cpu scan_58.0
514 700000061fff778 700000061f5ccf8 2 cond wait await_MC59 6cpu scan_59.0
515 700000061d23910 700000061f5d520 2 cond wait await_MC60 4cpu scan_60.0
516 700000061ff0668 700000061f5dd48 2 cond wait await_MC61 4cpu scan_61.0
517 7000000620d3800 700000061f5e570 2 cond wait await_MC62 7cpu scan_62.0
518 700000061d33a20 700000061f5ed98 2 cond wait await_MC63 4cpu scan_63.0
519 700000064dc7bb8 700000061f5f5c0 2 cond wait await_MC64 4cpu scan_64.0
520 700000064decd50 700000061f5fde8 2 cond wait await_MC65 3cpu scan_65.0
521 700000064cee578 700000061f521b0 2 cond wait await_MC66 3cpu scan_66.0
522 700000061e9f028 700000061f60610 2 cond wait await_MC67 6cpu scan_67.0
523 700000061dea668 700000061f60e38 2 cond wait await_MC68 5cpu scan_68.0
524 700000061f31888 700000061f61660 2 cond wait await_MC69 3cpu scan_69.0
525 7000000622baa20 700000061f61e88 2 cond wait await_MC70 4cpu scan_70.0
526 700000064e91c40 700000061f626b0 2 cond wait await_MC71 4cpu scan_71.0
527 700000064efedd8 700000061f62ed8 2 cond wait await_MC72 3cpu scan_72.0
528 700000061ef9028 700000061f63700 2 cond wait await_MC73 4cpu scan_73.0
529 700000061cf1130 700000061f63f28 2 cond wait await_MC74 6cpu scan_74.0
530 700000061d60340 700000061f64750 2 cond wait await_MC75 4cpu scan_75.0
531 700000061ebd4d0 700000061f64f78 2 cond wait await_MC76 3cpu scan_76.0
532 700000061dcb778 700000061f657a0 2 cond wait await_MC77 6cpu scan_77.0
533 7000000621a7910 700000061f65fc8 2 cond wait await_MC78 3cpu scan_78.0
534 700000065004aa8 700000061f667f0 2 cond wait await_MC79 4cpu scan_79.0
535 70000006216b1b0 700000061f67018 2 cond wait await_MC80 5cpu scan_80.0
536 700000061edb340 700000061f67840 2 cond wait await_MC81 4cpu scan_81.0
537 700000062189558 700000061f68068 2 cond wait await_MC82 3cpu scan_82.0
538 70000006205a2b8 700000061f68890 2 cond wait await_MC83 5cpu scan_83.0
539 700000061e72028 700000061f690b8 2 cond wait await_MC84 4cpu scan_84.0
540 700000061dd91b0 700000061f698e0 2 cond wait await_MC85 3cpu scan_85.0
541 7000000620c4028 700000061f6a108 2 cond wait await_MC86 6cpu scan_86.0
542 7000000620c4ca0 700000061f6a930 2 cond wait await_MC87 3cpu scan_87.0
543 700000065144d58 700000061f6b158 2 cond wait await_MC88 4cpu scan_88.0
544 700000061d9d028 700000061f6b980 2 cond wait await_MC89 7cpu scan_89.0
545 700000061e08130 700000061f6c1a8 2 cond wait await_MC90 3cpu scan_90.0
546 70000006226a2b8 700000061f6c9d0 2 cond wait await_MC91 3cpu scan_91.0
547 700000061f03028 700000061f6d1f8 2 cond wait await_MC92 5cpu scan_92.0
548 7000000621b71b0 700000061f6da20 2 cond wait await_MC93 4cpu scan_93.0
549 700000061d053c8 700000061f6e248 2 cond wait await_MC94 3cpu scan_94.0
550 7000000620fe4d0 700000061f6ea70 2 cond wait await_MC95 4cpu scan_95.0
551 70000006200f230 700000061f6f298 2 cond wait await_MC96 3cpu scan_96.0
552 7000000622c8448 700000061f6fac0 2 cond wait await_MC97 5cpu scan_97.0
553 7000000619d6028 700000061f702e8 2 cond wait await_MC98 1cpu scan_98.0
554 7000000620871b0 700000061f70b10 2 cond wait await_MC99 5cpu scan_99.0
555 700000061f083c8 700000061f71338 2 cond wait await_MC10 4cpu scan_100.0
556 70000006217a558 700000061f71b60 2 cond wait await_MC10 3cpu scan_101.0
557 700000065378c40 700000061f72388 2 cond wait await_MC10 4cpu scan_102.0
558 700000065457dd8 700000061f72bb0 2 cond wait await_MC10 7cpu scan_103.0
559 700000061fa34d0 700000061f733d8 2 cond wait await_MC10 7cpu scan_104.0
560 700000061a006f0 700000061f73c00 2 cond wait await_MC10 5cpu scan_105.0
561 70000006225f3c8 700000065515028 2 cond wait await_MC10 4cpu scan_106.0
562 70000006540eaa8 700000065515850 2 cond wait await_MC10 6cpu scan_107.0
563 7000000622e6130 700000065516078 2 cond wait await_MC10 6cpu scan_108.0
564 70000006212f340 7000000655168a0 2 cond wait await_MC10 5cpu scan_109.0
566 7000000655ae028 7000000655170c8 2 cond wait netnorm 1cpu sqlexec
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Work: 703-733-4126
Pager: 703-705-9241
Email Pager: 7037059241@my2way.com
Home: 703-430-0805
Cell: 703-477-6045
========================
Messages In This Thread
- many threads for process ?
Floyd Wellershaus -- Friday, 4 February 2005, at 7:53 a.m.
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
