Re: Activating / Rebuilding Statistics

Sha wrote:

> Hi
>
> We are running Oracle v 8.1.7.
> Can someone kindly tell me how to check/activate if the statistics for the
> tables are turned on ?
>
> Thanks in advance.

SELECT max(last_ddl_date)
FROM user_objects;

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)