RE: Manual analyze 10g

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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of P D Sent: maandag 14 november 2011 15:39
To: oracle-l_at_freelists.org
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.                                                 

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 14 2011 - 10:20:41 CST