Re: Manual analyze 10g

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: pdba1966@xxxxxxxxxxx
  • Date: Mon, 14 Nov 2011 16:19:11 +0000

Assuming that they *don't* want to run analyze but do want to run
dbms_stats then as of 10g (maybe 10.2)
will help you out. See also for
an overview. Are they gathering stats at the end of a data load, or after
index maintenance - if the latter their new stats are probably there

On Mon, Nov 14, 2011 at 2:38 PM, P D <pdba1966@xxxxxxxxxxx> wrote:

> I've got a database and the developers want to run analyze on one
> table even though Oracle automates it in this version.   If I run this for
> them and have any issues, is there a way to revert back to the old
> statistics?     Are there any other potential side effects of running it on
> one table in this version of Oracle.
> --

Niall Litchfield
Oracle DBA


Other related posts: