Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What system table shows when a table was last analyzed?

Re: What system table shows when a table was last analyzed?

From: Brian Peasey <bpeasey_at_doncarsys.com>
Date: Tue, 16 Jul 2002 13:02:27 GMT
Message-ID: <DPUY8.61125$pi1.5505454@news2.calgary.shaw.ca>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:0cfriug3t9hejpgar4qg5i8tmi312hsrjt_at_4ax.com...

> Select * from dict_columns where column_name like '%ANALYZE%'
> should also have done the tric.

Thank you.

> Please use it next time to avoid questions you could easily have
> looked up yourself.

Just remember Sybrand...at one time you didn't know the answer to this question either.

Regards,
Brian Received on Tue Jul 16 2002 - 08:02:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US