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
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