OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Analyze Command

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

Analyze Command [message #189645]

Fri, 25 August 2006 07:15

javed122
Messages: 19
Registered: April 2005
Location: Mumbai

Junior Member

Hi All,

I have run ANALYZE TABLE t1 COMPUTE STATISTICS on oracle9i with Windows2000 OS,can anyone inform on which table or location i am able to see the Statistics of same as well which parameter is important to look on statistics.

Report message to a moderator

Re: Analyze Command [message #189650 is a reply to message #189645]

Fri, 25 August 2006 07:36

aorehek
Messages: 52
Registered: August 2006

Member

You can look in user_tables, user_tab_columns.
There is column last_analyzed.

Report message to a moderator

Re: Analyze Command [message #189657 is a reply to message #189645]

Fri, 25 August 2006 08:00

javed122
Messages: 19
Registered: April 2005
Location: Mumbai

Junior Member

Thanks very much,
Can you tell me which parameter are important

Report message to a moderator

Re: Analyze Command [message #189754 is a reply to message #189657]

Sat, 26 August 2006 08:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Which paramters are imortant is really site specific. Rather than using ANALYZE ... COMPUTE STATISTICS, you may want to consider DBMS_STATS instead (Using the DBMS_STATS Package).

Report message to a moderator

Re: Analyze Command [message #189858 is a reply to message #189754]

Mon, 28 August 2006 02:42

javed122
Messages: 19
Registered: April 2005
Location: Mumbai

Junior Member

Thanks all of you really useful link

Report message to a moderator

Previous Topic:	the outline error why
Next Topic:	SLOW Updates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 13:29:48 CST 2024