RE: gather stats on partitioned tables
Date: Wed, 16 Apr 2014 19:22:58 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF06B96462_at_NC2PWEX501.us.ad.lfg.com>
Make sure you're preferences aren't set to not publish stats by default: http://docs.oracle.com/cd/E11882_01/server.112/e16638/stats.htm#PFGRF94751
Thanks,
Scott
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
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 16 2014 - 21:22:58 CEST