statistics on partitioned tables

From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Wed, 9 Feb 2011 08:10:11 -0800 (PST)
Message-ID: <d92599ca-d1c8-45ea-bf03-6923d23f8441_at_u6g2000vbh.googlegroups.com>

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 Received on Wed Feb 09 2011 - 10:10:11 CST