Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

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

Steve Adams

2006-04-27

Replies:

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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.