Hy, In 10gR2 Oracle is automatically creating backups of your cbo stats http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#i1045150 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: https://freekdhooge.wordpress.com/analyzethis/ </shameless plug> Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of P D Sent: maandag 14 november 2011 15:39 To: oracle-l@xxxxxxxxxxxxx Subject: Manual analyze 10g I've got a 10.2.0.4 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. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l