Hi all .. I'm trying to understand why WRI$_OPTSTAT_TAB_HISTORY is not showing this table to be analyzed on 7th and 8th (weekend days). Take into consideration ... - I confirmed auto stats job did run on these 2 days (starting at 6am). - If the explanation that it did not qualify because of the % stale, then why it did on previous days when rowcnt was 0. OWNER OBJECT_NAME DATE_TIME ROWCNT ------------------------------ --------------------- ---------------------------------------- ---------- me my_table 12/12/2011 10:05:40 P.M.,694142 -06:00 0 me my_table 12/13/2011 10:02:04 P.M.,477687 -06:00 0 me my_table 12/14/2011 10:01:30 P.M.,703519 -06:00 0 me my_table 12/15/2011 10:01:34 P.M.,938617 -06:00 0 me my_table 12/16/2011 10:04:31 P.M.,764455 -06:00 0 me my_table 12/19/2011 10:01:08 P.M.,347911 -06:00 0 me my_table 12/20/2011 10:05:41 P.M.,998361 -06:00 0 me my_table 12/21/2011 10:01:11 P.M.,897349 -06:00 0 me my_table 12/22/2011 10:01:17 P.M.,887991 -06:00 0 me my_table 12/23/2011 10:01:07 P.M.,227835 -06:00 0 me my_table 12/27/2011 10:02:26 P.M.,651370 -06:00 0 me my_table 12/28/2011 10:04:21 P.M.,056111 -06:00 0 me my_table 12/29/2011 10:01:37 P.M.,539184 -06:00 0 me my_table 12/30/2011 10:01:18 P.M.,892029 -06:00 0 me my_table 01/01/2012 02:10:27 P.M.,903246 -06:00 0 me my_table 01/02/2012 10:01:04 P.M.,129002 -06:00 0 me my_table 01/03/2012 10:02:07 P.M.,763137 -06:00 0 me my_table 01/04/2012 10:01:18 P.M.,437628 -06:00 0 me my_table 01/05/2012 10:04:33 P.M.,415439 -06:00 0 me my_table 01/06/2012 10:01:22 P.M.,395165 -06:00 0 me my_table 01/09/2012 10:00:22 P.M.,567054 -06:00 101 -- //www.freelists.org/webpage/oracle-l