Re: statistics on partitioned tables

> 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://blogs.oracle.com/optimizer/2009/02/maintaining_statistics_on_large_partitioned_tables.html

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