Re: How to identify the last db stats run - Estimate / Compute?
- From: arul kumar <arul76_2000@xxxxxxxxx>
- To: steve.adams@xxxxxxxxxxxx
- Date: Fri, 28 Apr 2006 14:15:18 -0700 (PDT)
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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
