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 - 01:49:09 CST