Re: In search of script to generate analyze command

From: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Wed, 20 Oct 2004 20:07:58 GMT
Message-ID: <yAzdd.21382$_u6.20809@edtnps89>

Patrick Burns wrote:
> I am in search of a generic script that will run everyday in our
> nightly cycle and write to an sql file an analyze statement if a
> certain percentage of the rows have changed, 20%. Then every weekend
> use dbms_stats to analyze the tables and indexes.
>
> I have seen these types of things in this group but can't seem to find
> one around.

Oracle version? If 9i+, then allow dbms_stats to execute when your data is stale etc. Received on Wed Oct 20 2004 - 15:07:58 CDT

This message: [ Message body ]
Next message: Ed Stevens: "Re: Need Statspack help"
Previous message: JL: "What does EXTERN, NORMAL, HIGH types mean for ASM diskgroups?"
In reply to: Patrick Burns: "In search of script to generate analyze command"
Next in thread: Patrick Burns: "Re: In search of script to generate analyze command"
Reply: Patrick Burns: "Re: In search of script to generate analyze command"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US