Home » RDBMS Server » Performance Tuning » Analyze Command
Analyze Command [message #189645] Fri, 25 August 2006 07:15 Go to next message
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.
Re: Analyze Command [message #189650 is a reply to message #189645] Fri, 25 August 2006 07:36 Go to previous messageGo to next message
aorehek
Messages: 52
Registered: August 2006
Member
You can look in user_tables, user_tab_columns.
There is column last_analyzed.
Re: Analyze Command [message #189657 is a reply to message #189645] Fri, 25 August 2006 08:00 Go to previous messageGo to next message
javed122
Messages: 19
Registered: April 2005
Location: Mumbai
Junior Member
Thanks very much,
Can you tell me which parameter are important
Re: Analyze Command [message #189754 is a reply to message #189657] Sat, 26 August 2006 08:20 Go to previous messageGo to next message
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).
Re: Analyze Command [message #189858 is a reply to message #189754] Mon, 28 August 2006 02:42 Go to previous message
javed122
Messages: 19
Registered: April 2005
Location: Mumbai
Junior Member
Thanks all of you really useful link
Previous Topic: the outline error why
Next Topic: SLOW Updates
Goto Forum:
  


Current Time: Wed Dec 07 16:35:39 CST 2016

Total time taken to generate the page: 0.15650 seconds