RE: Manual analyze 10g

From: D'Hooge Freek <>
Date: Mon, 14 Nov 2011 17:20:41 +0100
Message-ID: <>


In 10gR2 Oracle is automatically creating backups of your cbo stats

You can run dbms_stats on the requested table if you don't want to use the default options, otherwise there is little use in doing this.

In 11g you can speficy which options you want to use for a specific table and the automatic job will then use those options for that table and the default options for the other tables.

<shameless plug>
For 9i and 10g I have created a package that allows you to define defaults for different level (db schema, table, partition, ...). You can download it here: </shameless plug>


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

-----Original Message-----

From: [] On Behalf Of P D Sent: maandag 14 november 2011 15:39
Subject: Manual analyze 10g

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.                                                 


-- Received on Mon Nov 14 2011 - 10:20:41 CST

Original text of this message