OraFAQ Forum: Performance Tuning » Analyze table&Index

Home » RDBMS Server » Performance Tuning » Analyze table&Index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Analyze table&Index [message #116465]

Wed, 20 April 2005 04:00

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

Report message to a moderator

Re: Analyze table&Index [message #116474 is a reply to message #116465]

Wed, 20 April 2005 05:16

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Known bug.
First delete the previous statistics and then collect again.

Report message to a moderator

Re: Analyze table&Index [message #116482 is a reply to message #116465]

Wed, 20 April 2005 05:51

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thank you

Report message to a moderator

Re: Analyze table&Index [message #116523 is a reply to message #116465]

Wed, 20 April 2005 08:53

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

And might as well start using dbms_stats package.

Report message to a moderator

Previous Topic:	Count oracle user process
Next Topic:	tuning question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 21:11:05 CDT 2024