Re: gather stale and Histograms

Dana Day wrote:
>
> Hello,
>
> I manage several databases and have recently converted to using
> dbms_stats.gather_schema_stats with the gather stale option.
> A significant number of tables/columns also have histograms which are
> reset after dbms_stats is run.
>
> What I want to do is have a routine that will dynamically gather stale
> and immediately after, regenerate histograms if needed.
> A couple of thoughts I have had would be to generate a temp table for
> this purpose and use %_histograms to re-gather histograms after
> running dbms_stats.
>
> Is anyone else doing similar, and would you share the wisdom?
>
> TIA,
>
> Dana Day
> Phoenix, AZ
> Environment: AIX 4.3/8.1.7.2, W2K/9.2.0, AIX 4.3/9.2.0.2.

Doesn't gather_stale have an OUT parameter which lists the objects processed? You could use this to subsequently loop through to do any additional processing you require.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"