Home » RDBMS Server » Performance Tuning » Statistic
icon5.gif  Statistic [message #161039] Wed, 01 March 2006 09:50 Go to next message
zoltanp
Messages: 58
Registered: March 2005
Location: Hungary
Member
I made statistic with DBMS_UTILITY.ANALIZE_SCHEMA.

I would like to see the result of this statistic. How can I see it, and where(in which table) are stored the statistics?

And I would like to know what are the diferences between the DBMS_UTILITY.ANALIZE_SCHEMA and the DBMS_STATS.GATHER_SCHEMA_STATS?

Zoltan Patalenszki

Report message to a moderator

Re: Statistic [message #161040 is a reply to message #161039] Wed, 01 March 2006 09:55 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
DBMS_UTILITY.ANALIZE_SCHEMA is old and outdated and not even supported in 10g.
Use Gather_schema_stats.
>>How can I see it, and where(in which table) are stored the statistics?
dba/user tables/indexs/all *stat* views.

Report message to a moderator

Previous Topic: what are the steps to follow to coalesce
Next Topic: Execution Plan doubt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 14:40:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.