Re: Stats 10g
From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Thu, 11 Nov 2010 08:17:28 +0800
Message-ID: <AANLkTim0_PXGDEkZn=VPrhzoc0Akz_tiByuih4nTjozA_at_mail.gmail.com>
DBMS_STATS.RESTORE_TABLE_STATS takes a TIMESTAMP argument and restores the "latest" stats as existed closest to the timestamp. The default retention of stats is 30 days.
Date: Thu, 11 Nov 2010 08:17:28 +0800
Message-ID: <AANLkTim0_PXGDEkZn=VPrhzoc0Akz_tiByuih4nTjozA_at_mail.gmail.com>
DBMS_STATS.RESTORE_TABLE_STATS takes a TIMESTAMP argument and restores the "latest" stats as existed closest to the timestamp. The default retention of stats is 30 days.
Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone
On Nov 11, 2010 12:31 AM, "J. Dex" <cemail_219_at_hotmail.com> wrote:
If we manually run dbms_stats on some tables and find it created more issues than it helped, is there an easy way to back out of it and go back to the statistics that Oracle was previously using?
This is 10g and flashback is not being used.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 10 2010 - 18:17:28 CST