OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Statistic

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

Statistic [message #161039]

Wed, 01 March 2006 09:50

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 06 05:57:41 CDT 2026