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

  • From: Steve Adams <steve.adams@xxxxxxxxxxxx>
  • To: arul76_2000@xxxxxxxxx
  • Date: Thu, 27 Apr 2006 20:37:51 +1000

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


Other related posts: