RE: analyze,urgent!

RE: analyze,urgent!

 

  

user_table.sample_size

-----Original Message-----
From: Bernita Joseph [mailto:[Email Address Removed] Friday, February 28, 2003 1:48 PM
To: LazyDBA.com Discussion
Subject: analyze,urgent!


Hi all,

I know that the user_tables contain the information regarding tables that
has been analyzed.
But which column has the num of rows analyzed information.
ie: analyse table table_a estimate statistics sample 100 rows;

Where does the 100 rows analyzed info stored?

Thanks!


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page