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


regards
Chris B

Chris wrote ...

Try some google searches with words like "oracle statistics management
partitioned tables" and you get hits like these ...

http://blogs.oracle.com/optimizer/20..._tables .html

http://oracledoug.com/serendipity/in...es-Part-1.html

On Feb 9, 1:20*pm, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
I have found that if a partition has NO stats, the performance can be
very slow, but just adding ANY stats - even a zero (0) would make it
perform. Each partition was fairly large.