Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> found dead multi-threaded server error

found dead multi-threaded server error

From: Siddharth <siddharthbahri_at_yahoo.com>
Date: 4 Mar 2002 23:49:09 -0800
Message-ID: <fede6a7c.0203042349.1d6db0f5@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:

Received on Tue Mar 05 2002 - 01:49:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US