Re: GLOBAL_STATS

• Post for FREE via your newsreader at post.usenet.com ****

Hi Holger

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:ckj5pl$mp$1_at_news.BelWue.DE...
[snip]
> The automatic statististic gathering only gatheres statistics for tables
> that
> a) have monitoring set to yes (check dba_tables for those tables)

Be carefull, in 10g the MONITORING clause is deprecated. The monitoring is automatically enabled at database level if STATISTICS_LEVEL is set to TYPICAL (default) or ALL.

> b) changed enough so the gather stale option of dbms_stats kicks in
>
> I'm a bit missing why you conclude that the value for GLOBAL_STATS
influences
> automatic statistics gathering. It should be the other way round. Perhaps
> you care to sched some light on your findings?
>
> Cheers,
>
> Holger

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=