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.

Report message to a moderator

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: 10708
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 11:25:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.