| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_stats result ora-600
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
--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.Received on Wed May 24 2006 - 07:30:25 CDTHi,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
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
 |
 |