dday1960_at_hotmail.com (Dana Day) wrote in message news:<7cf47471.0305070519.3ad3fd7e_at_posting.google.com>...
> 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.
Have not gotten around to test this... But you can recreate histograms
with "method_opt" while you GATHER STALE for the objects with stale
statistics at the same time, no?
Received on Wed May 07 2003 - 14:55:25 CDT
