Re: dbms_stats.gather_schema_stats

klabu wrote:
> I have 15 tables, about 7 mil rows in total
>
> SQL> exec dbms_stats.gather_schema_stats(user);
>
> Executed in 469.305 seconds
>
> Is it "normal" that dbms_stats.gather_schema_stats takes that long ?
>
>

Which version of Oracle?

As David already said, it can take a long time gather stats for an entire schema, depending on many factors. The primary factor is the size of the segments in the schema, but it is not the only one.

There are methods to gather schema stats faster. You can perform the operation in parallel. You can only gather "stale" stats. These are just a few.

HTH,
Brian

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

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown