RE: gather stats on partitioned tables
Date: Wed, 16 Apr 2014 15:52:44 -0400
Message-ID: <0d5d01cf59ad$6fcfd720$4f6f8560$_at_rsiz.com>
I'd look into Doug Burns' stuff on this topic. Either via www.oaktable.net or directly at http://oracledoug.com/serendipity/
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Sandra Becker
Sent: Wednesday, April 16, 2014 3:15 PM
To: oracle-l
Subject: gather stats on partitioned tables
Oracle EE 11.2.0.2
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 16 2014 - 21:52:44 CEST