Re: dbms_stats result ora-600
- From: fairlie rego <fairlie_r@xxxxxxxxx>
- To: ujang_jaenudin@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 May 2006 19:02:34 -0700 (PDT)
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxx (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
--
//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.
Other related posts:
