Re: gather stats on partitioned tables

From: David Fitzjarrell <>
Date: Wed, 16 Apr 2014 12:31:35 -0700 (PDT)
Message-ID: <>

How are you generating the statistics on those two  partitioned tables?  As a f irst guess it may be causing  your heartburn; I cannot get to behave that way but possibly my tests aren't reflecting how you imported these partitions. Any information on your process would be most  helpful.   David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Wednesday, April 16, 2014 1:15 PM, Sandra Becker <> wrote: Oracle EE   As part of a POC project, I had to import 8 partitioned tables into a new database.  Six of them are partitioned on yyyymmdd and I had no problems with them.  The last two are range partitioned on an ID column (sequence used to set the ID value).  Once I found the correct partitions to match the tables partitioned by date range, I imported them.   My problem:  I cannot get those last two tables to show that they have been analyzed or show a difference in the number of rows for each partition, even though some of the partitions do not have data in the new database.  The stats are not locked; checked that first.  I've googled and gone to MOS, but nothing I've found so far would tell me why I can't get the stats to change.  Suggestions?   Thank you. -- Sandy GHX
Received on Wed Apr 16 2014 - 21:31:35 CEST

Original text of this message