Re: analyze command

From: Francis Wong <wongfrancis_at_home.com>
Date: 2000/04/15
Message-ID: <3Y4K4.41801$m5.809207@news1.rdc2.on.home.com>#1/1

In fact, I am looking at the date it is last analyzed. Got any idea?

"Karl Hewlett" <fake_address_at_auckland.ac.nz> wrote in message news:8d648u$fpj$1_at_scream.auckland.ac.nz...
> look in dba_tables in oracle 8
>
> Karl
>
> Jerry Gitomer <jgitomer_at_erols.com> wrote in message
> news:20000414.4405300_at_noname.nodomain.nowhere...
>
> Yes,
>
> In Oracle 7 look in user_tab_columns. (Yeah, you certainly wouldn't
> expect to find it there, but it is). In Oracle 8 I believe it is in a
> more reasonable place, but I don't remember where.
>
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 4/13/00, 6:44:18 PM, "Francis Wong" <wongfrancis_at_home.com> wrote
> regarding analyze command:
>
>
> > Is there a way to find out when a table is analyzed last time?
>
>
>
>
>
Received on Sat Apr 15 2000 - 00:00:00 CDT