Home » RDBMS Server » Performance Tuning » Analyze table&Index
icon5.gif  Analyze table&Index [message #116465] Wed, 20 April 2005 04:00 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Hi,

I analyze table and index by take issue
"analyze table tmp compute statistics for table for all indexed columns;"
and got error
ORA-00600: internal error code, arguments: [16515], [D], [23], [3031], [7],[0], [], []

oracle :8i
solaris :2.8

Any suggestion ? and Thanks for advance

Chara
Re: Analyze table&Index [message #116474 is a reply to message #116465] Wed, 20 April 2005 05:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Known bug.
First delete the previous statistics and then collect again.
Re: Analyze table&Index [message #116482 is a reply to message #116465] Wed, 20 April 2005 05:51 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thank you
Re: Analyze table&Index [message #116523 is a reply to message #116465] Wed, 20 April 2005 08:53 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
And might as well start using dbms_stats package.
Previous Topic: Count oracle user process
Next Topic: tuning question
Goto Forum:
  


Current Time: Thu Oct 01 02:26:13 CDT 2020