RE: Stats 10g

  • From: Michael McMullen <ganstadba@xxxxxxxxxxx>
  • To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 10 Nov 2010 11:43:45 -0500

Use dbms_stats to create a stat table and the same package to export/import
stats. Not the imp/exp utility.

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of J. Dex
Sent: Wednesday, November 10, 2010 11:30 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Stats 10g

 

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.

Other related posts: