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

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<6bo8jug5jlrdhg85f488hd5llr66hkvvdd_at_4ax.com>...
> On Tue, 16 Jul 2002 13:02:27 GMT, "Brian Peasey"
> <bpeasey_at_doncarsys.com> wrote:
>
> >
> >"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
> >
> >
> >
>
> At that time the Internet was restricted to universities, and I was on
> my own. So once I learned the existence of dict, I was always using it
> to answer questions like 'in which datadictionary view is...'.
> It doesn't harm to make at least *some* effort to resolve your own
> questions, you will have the answer definitely faster then when you
> crosspost your question to all three Oracle newsgroups.
> Also and more importantly, you will *learn* from it, and you will get
> familiar with the logic behind the datadictionary. You will *never*
> learn that when you go on to rely on people never getting tired to
> answer the same boring questions over and over again.
>
> Regards
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Hear, Hear.

Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime. -- Chinese Proverb

Same principle.

Tom Swier

It is better to keep your mouth closed and let people think you are a fool than to open it and remove all doubt. -- Mark Twain Received on Wed Jul 17 2002 - 10:34:37 CDT