Re: Stats Gathering - 11g
- From: David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>
- To: ebadi01@xxxxxxxxx
- Date: Wed, 27 Apr 2011 22:51:41 +0100
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@xxxxxxxxx> 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
>
Other related posts:
