Re: found dead multi-threaded server error

Agree with Sybrand.

You might also want to see if you are running a multitier application with dedicated threads between the app server platform and the ORACLE rdbms platform. A lot of Web / Java / etc people think that they know the world, and attempt to rewrite Oracle code that has worked for many years.

check your $ORACLE_HOME/network/ directories and do a SHOW PARAMETERS while Oracle is running, as well as inspecting your initXXX.ora file; in my humble experience, MTS should never be used with dedicated threads.

And don't go trying to write your own connection management! Trust me it is quite gruesome and has been seldom worth the trouble.

RSH. "Siddharth" <siddharthbahri_at_yahoo.com> wrote in message news:fede6a7c.0203042349.1d6db0f5_at_posting.google.com...
> Hi,
>
> We are running Oracle 8.1.6 on a solaris server having 1GB of RAM. We
> are also running mod_perl on the same server. The db is configured for
> mts.
>
> I am getting the following error in my alert file:
>
> Mon Mar 4 23:45:03 2002
> found dead multi-threaded server 'S006', pid = (21, 92)
> found dead multi-threaded server 'S008', pid = (23, 20)
> found dead multi-threaded server 'S009', pid = (24, 7)
> found dead multi-threaded server 'S010', pid = (25, 4)
> found dead multi-threaded server 'S011', pid = (26, 3)
> found dead multi-threaded server 'S012', pid = (27, 3)
> found dead multi-threaded server 'S013', pid = (28, 3)
> Tue Mar 5 00:03:47 2002
> Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_s001_25832.trc:
> ORA-00600: internal error code, arguments: [16365], [2152407112], [0],
> [4], [], [], [], []
> Tue Mar 5 00:04:34 2002
> found dead multi-threaded server 'S001', pid = (18, 251)
> Tue Mar 5 00:22:20 2002
> Restarting dead background process EMN0
> EMN0 started with pid=19
>
> My SGA is as under:
> SQL> select * from v$sgastat;
>
> POOL NAME BYTES
> ----------- -------------------------- ----------
> fixed_sga 69616
> db_block_buffers 50331648
> log_buffer 163840
> shared pool free memory 8859076
> shared pool miscellaneous 929432
> shared pool db_block_buffers 835584
> shared pool State objects 292064
> shared pool table definiti 3008
> shared pool message pool freequeue 231152
> shared pool ktlbk state objects 131824
> shared pool pl/sql source 5732
>
> POOL NAME BYTES
> ----------- -------------------------- ----------
> shared pool fixed allocation callback 320
> shared pool trigger inform 520
> shared pool VIRTUAL CIRCUITS 452392
> shared pool enqueue_resources 104544
> shared pool long op statistics array 110000
> shared pool KQLS heap 735876
> shared pool table columns 18696
> shared pool PL/SQL DIANA 514240
> shared pool PLS non-lib hp 2096
> shared pool branches 74160
> shared pool db_handles 125000
>
> POOL NAME BYTES
> ----------- -------------------------- ----------
> shared pool type object de 43544
> shared pool dictionary cache 457584
> shared pool db_block_hash_buckets 229384
> shared pool transactions 274736
> shared pool trigger defini 6040
> shared pool KGFF heap 7116
> shared pool library cache 13261328
> shared pool KGK heap 4372
> shared pool sql area 26952964
> shared pool processes 192000
> shared pool sessions 591360
>
> POOL NAME BYTES
> ----------- -------------------------- ----------
> shared pool PL/SQL MPCODE 1032516
> shared pool event statistics per sess 949760
> shared pool joxs heap init 968
> shared pool DML locks 142912
> large pool free memory 48655912
> large pool session heap 496088
> java pool free memory 10756096
> java pool memory in use 217088
>
> 41 rows selected.
>
> Can someone tell me where the problem is?
>
> Rgds.
> -Siddharth
>
> PS: Following is an extract from one of the trace files being
> generated:
>
> *** SESSION ID:(29.7326) 2002-03-04 23:43:43.916
> ===================================================
> Dumping MTS state at level 10
> Global: Svc Name=orcl, Max Svrs=20, Max Disp=5, Max Ses=275
> Svrs: #act=12, #sta=1660, #trm=1788, #unt=140, #max=19
> Starting: flg=21, current=0, index=12
> Queue state
> COMMON : Current: 18, TotalQ: 3469752, TotalTime: 0
> ServiceQ: 804b1d48 804b1b48 804b1048 804b1248 804b2d48 804b0e48
> 804b1648 804b2a48 804b2548 804b1448 804b1c48 804b2048 804b2c48
> 804b1f48
> 804b0d48 804b0f48 804b1748 804b0b48
> DISP-D000: Current: 0, TotalQ: 0, TotalTime: 0
> ServiceQ:
> DISP-D001: Current: 0, TotalQ: 4188643, TotalTime: 0
> ServiceQ:
> DISP- : Current: 0, TotalQ: 0, TotalTime: 0
> ServiceQ:
> DISP- : Current: 0, TotalQ: 0, TotalTime: 0
> ServiceQ:
> DISP- : Current: 0, TotalQ: 0, TotalTime: 0
> ServiceQ:
> Dispatcher State
> D000: 804aecc0(1). Proc: 8010a538(1) flgs: 5, 3
> Own: 0, Total: 0, InTrans: 0
> Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:1, #Act: 1, Trm:
> 0, LastS: 0, Bk: 0
> D001: 804aed30(1). Proc: 8010a838(1) flgs: 5, 9
> Own: 32, Total: 52161, InTrans: 0
> Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:1, #Act: 1, Trm:
> 0, LastS: 0, Bk: 0
> D002: 804aeda0(0). Proc: 0(0) flgs: 0, 0
> Own: 0, Total: 0, InTrans: 0
> Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:1, #Act: 1, Trm:
> 0, LastS: 0, Bk: 0
> D003: 804aee10(0). Proc: 0(0) flgs: 0, 0
> Own: 0, Total: 0, InTrans: 0
> Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:1, #Act: 1, Trm:
> 0, LastS: 0, Bk: 0
> D004: 804aee80(0). Proc: 0(0) flgs: 0, 0
> Own: 0, Total: 0, InTrans: 0
> Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:1, #Act: 1, Trm:
> 0, LastS: 0, Bk: 0
> Server Info
> S000: 804ae3a8(24). Proc: 8010a238(34) Disp: 8010a838 VC: 804b1948
> flgs: 1
> InTrans:0 Byt:0 Brk:15234 Tvc: 33704 Nmg: 34
> S001: 804ae3ec(97). Proc: 8010ae38(107) Disp: 8010a838 VC: 804b2648
> flgs: 1
> InTrans:0 Byt:0 Brk:586 Tvc: 1297 Nmg: 107
> S002: 804ae430(52). Proc: 8010b138(74) Disp: 8010a838 VC: 804b2348
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 74
> S003: 804ae474(245). Proc: 8010b438(249) Disp: 8010a838 VC: 804b1a48
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 249
> S004: 804ae4b8(206). Proc: 8010b738(195) Disp: 8010a838 VC: 804b2b48
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 195
> S005: 804ae4fc(166). Proc: 8010ba38(136) Disp: 8010a838 VC: 804b2948
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 136
> S006: 804ae540(123). Proc: 8010bd38(92) Disp: 8010a838 VC: 804b1848
> flgs: 1
> S007: 804ae584(81). Proc: 8010c038(44) Disp: 8010a838 VC: 804b2e48
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 44
> S008: 804ae5c8(45). Proc: 8010c338(20) Disp: 8010a838 VC: 804b2848
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 20
> S009: 804ae60c(27). Proc: 8010c638(7) Disp: 8010a838 VC: 804b0c48
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 7
> S010: 804ae650(25). Proc: 8010c938(4) Disp: 8010a838 VC: 804b1348
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 4
> S011: 804ae694(21). Proc: 8010cc38(3) Disp: 8010a838 VC: 804b1548
> flgs: 1
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 3
> S012: 804ae6d8(14). Proc: 8010c638(6) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:0 Tvc: 0 Nmg: 6
> S013: 804ae71c(10). Proc: 8010c938(3) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:0 Tvc: 0 Nmg: 3
> S014: 804ae760(5). Proc: 8010c038(35) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:43 Tvc: 96 Nmg: 35
> S015: 804ae7a4(3). Proc: 8010c338(14) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:1 Tvc: 2 Nmg: 14
> S016: 804ae7e8(4). Proc: 8010ba38(109) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:0 Tvc: 0 Nmg: 109
> S017: 804ae82c(4). Proc: 8010c038(34) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:0 Tvc: 0 Nmg: 34
> S018: 804ae870(2). Proc: 8010de38(2) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:54 Tvc: 114 Nmg: 2
> S019: 804ae8b4(1). Proc: 8010d838(3) Disp: 0 VC: 0 flgs: 0
> InTrans:0 Byt:0 Brk:55 Tvc: 130 Nmg: 3
> Circuits:
> 804b0a48 f:100 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:103
> 804b0b48 f:c2 q:9 w:0 ob:0 bst:4/1 bsz:3/0 bo:0 m:119
> 804b0c48 f:c8 q:8 w:0 ob:0 bst:4/a bsz:3/614 bo:0 m:128
> Half-duplex protocol violation; dumping buffers:
Received on Tue Mar 05 2002 - 22:07:56 CST