dbms_stats result ora-600

From: Ujang Jaenudin <ujang_jaenudin_at_yahoo.com.sg>
Date: Wed, 24 May 2006 08:27:03 +0700
Message-ID: <003201c67ed1$2c6885f0$a8556e0a@jpcid.com>

dear all,
do you have experience regarding these errors? pls help me....
oracle 9ir2.0.1
redhat 7.1, dual xeon processors
ram 1gb

begin
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [16515], [D], [40], [95866], [3],
[0], [], []

ORA-06512: at "SYS.DBMS_STATS", line 9136
ORA-06512: at "SYS.DBMS_STATS", line 9616
ORA-06512: at "SYS.DBMS_STATS", line 9800
ORA-06512: at "SYS.DBMS_STATS", line 9854
ORA-06512: at "SYS.DBMS_STATS", line 9831
ORA-06512: at line 2

alert_<SID>.log
Wed May 24 08:01:49 2006
Errors in file /home/oracle/admin/bpms/udump/bpms_ora_16336.trc: ORA-00600: internal error code, arguments: [16515], [D], [40], [95866], [3],
[0], [], []

/home/oracle/admin/bpms/udump/bpms_ora_16336.trc Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /home/oracle/OraHome1
System name: Linux

Node name:      localhost.localdomain
Release:        2.4.2-2smp
Version:        #1 SMP Sun Apr 8 20:21:34 EDT 2001
Machine:        i686

Instance name: bpms
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 16336, image: oracle_at_localhost.localdomain (TNS V1-V3)

• SESSION ID:(14.2520) 2006-05-24 08:01:49.962
• 2006-05-24 08:01:49.962 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [16515], [D], [40], [95866], [3],
  [0], [], []
  Current SQL statement for this session: begin dbms_stats.gather_schema_stats(ownname=>'XXXX', method_opt=>'FOR ALL COLUMNS SIZE AUTO'); end; ----- PL/SQL Call Stack ----- object line object handle number name 0x5481d644 232 package body SYS.DBMS_STATS 0x5481d644 3092 package body SYS.DBMS_STATS 0x5481d644 8923 package body SYS.DBMS_STATS 0x5481d644 9067 package body SYS.DBMS_STATS 0x5481d644 9616 package body SYS.DBMS_STATS 0x5481d644 9800 package body SYS.DBMS_STATS 0x5481d644 9854 package body SYS.DBMS_STATS 0x5481d644 9831 package body SYS.DBMS_STATS 0x54f77a88 2 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+267 call 00000000 0 ? 5828D988 ? BFFFA158 ? 8457B3E ? 1 ? 0 ? ksfdmp()+25 call ksedmp()+0 3 ? A84D23C ? A8C5230 ? 258 ? 0 ? 4083 ?

--J

Send instant messages to your online friends http://asia.messenger.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 23 2006 - 20:27:03 CDT