RE: Manual analyze 10g
Date: Mon, 14 Nov 2011 17:20:41 +0100
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.
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>
Oracle Database Administrator
tel +32(0)3 451 23 82
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
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 Received on Mon Nov 14 2011 - 10:20:41 CST