Home » RDBMS Server » Performance Tuning » how to see the analyze table
how to see the analyze table [message #115346] Sun, 10 April 2005 01:51 Go to next message
ravivkumar
Messages: 34
Registered: April 2005
Location: chennai
Member

hi
i have set analyze to emp table , how to see that analyzed table.

bye.
Re: how to see the analyze table [message #115351 is a reply to message #115346] Sun, 10 April 2005 09:27 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
NOt sure what you are exactly looking into.
If you are looking for the timestamp for the date when you analyzed.
mag@mutation_mutation > select last_analyzed from user_tables where table_name='EMP';

LAST_ANAL
---------


mag@mutation_mutation > ANALYZE TABLE emp COMPUTE STATISTICS;

Table analyzed.

mag@mutation_mutation >  select last_analyzed from user_tables where table_name='EMP';

LAST_ANAL
---------
10-APR-05
Previous Topic: Oracle 9i Explian Plan output- TOAD
Next Topic: disk partition strategy for best performance...
Goto Forum:
  


Current Time: Wed Sep 30 11:12:32 CDT 2020