OraFAQ Forum: Performance Tuning » how to see the analyze table

Home » RDBMS Server » Performance Tuning » how to see the analyze table

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

how to see the analyze table [message #115346]

Sun, 10 April 2005 01:51

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

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.

Code: [Select all] [Show/ hide]

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 22:57:40 CDT 2025