Re: Stats 10g

From: Hemant K Chitale <>
Date: Thu, 11 Nov 2010 08:17:28 +0800
Message-ID: <>

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
sent from my smartphone

On Nov 11, 2010 12:31 AM, "J. Dex" <> 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.

Received on Wed Nov 10 2010 - 18:17:28 CST

Original text of this message