Re: How to identify the last db stats run - Estimate / Compute?

Hi,

You have the column SAMPLE_SIZE in dba_tables which inform you the number of rows scanned. If you gather statistics on static tables (although it would be a bad idea) this number must be the same as select count(*) from the static table.

Best Regards

On 4/27/06, arul kumar <arul76_2000_at_yahoo.com > wrote:
>
> All,
>
> Is there any data dictionary view to find out whether
> the last database statistics run was a ESTIMATE or
> COMPUTE one?
>
> Thanks,
> Arul.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Domingo Diaz Saenz

--
http://www.freelists.org/webpage/oracle-l