Re: analyze command

In which version of Oracle?

select * from v$version;

Oracle8 Enterprise Edition Release 8.0.5.1.1 - Production

    <snip>

desc dba_tables;

OWNER N VARCHAR2 30
TABLE_NAME N VARCHAR2 30
    <snip>
LAST_ANALYZED Y DATE 7
    <snip>

Francis Wong <wongfrancis_at_home.com> wrote in message news:3Y4K4.41801$m5.809207_at_news1.rdc2.on.home.com...
> 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 Sun Apr 16 2000 - 00:00:00 CDT