I seem to remember that gather_schema_stats does a compute statistics
if you give it no further directions. Or auto_sample_size which may
amount to the same when there are not much statistics already present.
Of course it is all depending on hardware and parameter settings but
almost 8 minutes for 7 million rows seems a bit long for any serious
hardware.
You can always trace the gather with statspack to see if there are any
serious wait problems.
Regards,
Eric.
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 ?
Received on Wed Oct 11 2006 - 12:44:19 CDT
