Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When Can I Run Analyze?
"David LeJeune" <dlejeune_at_yahoo.com> wrote in message
news:f329f8a7.0111080845.50e113c7_at_posting.google.com...
> Hi -
>
> Can a full COMPUTE analyze be run for a schema (i.e. let's say I put
> an execution of dbms_utility.analyze_schema into my cron to be run
> once a day) even if the database is a real-time system.
>
> Let's say the database is processing hundreds of transactions per
> second, what is the best methodology for analyzing the schema? Can it
> be safely done while the transactions are occuring (w/ a 24x7 system I
> don't have much of a choice unfortunately).
Yes it can. You night find it better though to do an estimate, or to use stored outlines.
-- Niall Litchfield Oracle DBA Audit Commission UkReceived on Fri Nov 09 2001 - 03:17:53 CST