Re: statistics on partitioned tables
Date: Wed, 9 Feb 2011 10:20:08 -0800 (PST)
Chris wrote ...
> oracle 10.2.0.4 enterprise windows 2003 service pack 2
> 1) Code we use is driven by concept of list of stale objects at
> table level
> eg dbms_stats.gather_schema_stats ( ....options list stale etc )
> 2) Is there scope for listing staleness at partition level
> Ie if partition 1 goes stale or partition 2 goes stale refresh
> stats for partition and possibly table
Try some google searches with words like "oracle statistics management partitioned tables" and you get hits like these ...
http://oracledoug.com/serendipity/index.php?/archives/1562-Statistics-on-Partitioned-Tables-Part-1.html Received on Wed Feb 09 2011 - 12:20:08 CST