statistics on partitioned tables

From: dba cjb <>
Date: Wed, 9 Feb 2011 08:10:11 -0800 (PST)
Message-ID: <>

oracle 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

Chris B Received on Wed Feb 09 2011 - 10:10:11 CST

Original text of this message