Re: gather stats on partitioned tables

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Wed, 16 Apr 2014 14:06:16 -0600
Message-ID: <CAJzM94BRHNe5_FNxpSy78u8+3Wy8vbRcC0WMsWwWr4TvNpJXrQ_at_mail.gmail.com>

Thanks, everyone. Scott nailed. The database is set to "not" publish stats. Once I published them, everything was good.

Sandy

On Wed, Apr 16, 2014 at 1:52 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> 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
>

-- 
Sandy
Transzap, Inc.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 16 2014 - 22:06:16 CEST