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: Wed, 24 May 2006 08:30:25 -0400
Message-ID: <20060524123025.GB15859@iris.uqtr.ca>


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.

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@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@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





Fairlie Rego
Senior Oracle Consultant
Optus Telecommunications
 


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 Wed May 24 2006 - 07:30:25 CDT

Original text of this message

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