Re: How to identify the last db stats run - Estimate / Compute?
- From: "Domingo Diaz Saenz" <domingo.diazs@xxxxxxxxx>
- To: arul76_2000@xxxxxxxxx
- Date: Thu, 27 Apr 2006 12:46:55 +0200
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@xxxxxxxxx > 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Domingo Diaz Saenz
Other related posts:
