Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why people delete statistics bore running statistics
G Quesnel wrote:
> Actually, there could be a (valid?) reason ...
> - could be used to regenerate all stats instead of just stale stats
> (when auto is used)
> - could be used to regenerate all stats, when statistics had been
> previously 'locked'
> - I don't know if this could impact how old statistics are moved to the
> AWR
> - there could also be an impact if the previous statistics were
> generated with the Analyze statments
>
> Also note that this could be very bad in 10g, as the statistic
> generation could be limited to a window that is too short for the
> entire schema, so it could cause some segments to not get new stats.
>
> My 2cents
Also note that this could be very bad in 10g, as the statistic
generation could be limited to a window that is too short for the
entire schema, so it could cause some segments to not get new stats.
>> Thanks, but do not understand what do you mean? Please elaborate.
Received on Mon Oct 23 2006 - 13:04:56 CDT