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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_stats result ora-600

Re: dbms_stats result ora-600

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Tue, 23 May 2006 19:02:34 -0700 (PDT)
Message-ID: <20060524020234.10285.qmail@web31906.mail.mud.yahoo.com>


Hi,    

  From the information you have provided it appears to be bug 2252824 but I might be able to confirm if you send me the trace file.   Set _enable_type_dep_selectivity to true and see if it helps.    

  Regards,
Fairlie

Ujang Jaenudin <ujang_jaenudin_at_yahoo.com.sg> wrote:   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_.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)

--J

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

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





          Fairlie Rego
Senior Oracle Consultant
  Optus Telecommunications
  www.optus.com.au
   






		
---------------------------------
Ring'em or ping'em. Make  PC-to-phone calls as low as 1/min with Yahoo! Messenger with Voice.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 21:02:34 CDT

Original text of this message

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