WRI$_OPTSTAT_TAB_HISTORY not showing table stats on certain days: why?

From: fmhabash <fmhabash_at_gmail.com>
Date: Tue, 10 Jan 2012 13:36:03 -0500
Message-ID: <4F0C8513.2000706_at_gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 10 2012 - 12:36:03 CST