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

All,

Thanks for your inputs. It worked!

Tables with ESTIMATE  STATS:

SQL> select count(*) from dba_tables where
owner='SYSADM' and num_rows > 0  and num_rows <>
sample_size;

  COUNT(*)
----------
        14

Tables with COMPUTE  STATS:

SQL> select count(*) from dba_tables where
owner='SYSADM' and num_rows > 0  and
num_rows=sample_size;

  COUNT(*)
----------
      2624



Regards,
Arul.


--- Steve Adams <steve.adams@xxxxxxxxxxxx> wrote:

> Hi Arul,
> 
> Try selecting sample_size / num_rows from
> dba_tables.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/         - For DBAs
> @   http://www.christianity.net.au/  - For all
> 
> 
> arul kumar 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
> > 
> > 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 


__________________________________________________
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

Other related posts: