Re: gather stats on partitioned tables
- From: Karth Panchan <keyantech@xxxxxxxxx>
- To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>
- Date: Wed, 16 Apr 2014 16:06:07 -0400
I am not how big these two tables?
Did you tried delete stats first and gather stats with granularity ALL.
Karth
> On Apr 16, 2014, at 3:14 PM, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:
>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
