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

From: arul kumar <arul76_2000_at_yahoo.com>
Date: Fri, 28 Apr 2006 14:15:18 -0700 (PDT)
Message-ID: <20060428211518.74537.qmail@web54613.mail.yahoo.com>

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_at_ixora.com.au> 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

Received on Fri Apr 28 2006 - 16:15:18 CDT