Manual analyze 10g
From: P D <pdba1966_at_hotmail.com>
Date: Mon, 14 Nov 2011 09:38:31 -0500
Message-ID: <SNT115-W60CAF2F49A79B7C2B70A9AD0C00_at_phx.gbl>
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.
Date: Mon, 14 Nov 2011 09:38:31 -0500
Message-ID: <SNT115-W60CAF2F49A79B7C2B70A9AD0C00_at_phx.gbl>
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-lReceived on Mon Nov 14 2011 - 08:38:31 CST