Re: How is possible that avg_data_blocks_per_key = 0 even with fresh statistics ?

On Dec 6, 7:42 am, nicola.far..._at_info-line.it wrote:
> DBMS_STATS.GATHER_SCHEMA_STATS(user, METHOD_OPT => 'for all columns
> size 1', CASCADE => True);
>
> scheduled each day early morning
>

It isn't ownname=>'SCOTT' or something? Sorry if you are just hiding the real name, but I had to ask, sometimes these things are simply correct-syntax-with-wrong-usage.

jg

--
@home.com is bogus.
"I promised myself I would never say 'Dude' on the air, but...Dude!' -
radio announcer at Manhattan Beach, big waves.