Re: Stats Gathering - 11g

From: David Roberts <big.dave.roberts_at_googlemail.com>
Date: Wed, 27 Apr 2011 22:51:41 +0100
Message-ID: <BANLkTimvOBpgwszudE0Awtjty9j9dsbwBQ_at_mail.gmail.com>



Stats could be locked. (With no stats)

The stats gathering window could be too small - Oracle doesn't prioritorise the analysis of tables with more out of date stats, so if the stats job is continually running out of time, then sometimes some tables never have their stats gathered.

Dave

On Mon, Apr 25, 2011 at 6:47 PM, A Ebadi <ebadi01_at_yahoo.com> wrote:

> For some reason automatic stats gathering job is not picking up partitions
> of a fact table we are loading? It picks up standalone (dimension) tables
> OK.
>
> Platform is Oracle Exadata (11G).
>
> Any suggestions?
>
> Thanks,
> Abdul
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 27 2011 - 16:51:41 CDT

Original text of this message