Re: Stats 10g
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx, cemail_219@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Nov 2010 15:43:14 -0800 (PST)
AWR in 10g retains stats, try this-
exec dbms_stats.restore_table_stats ('<tbl_owner>','<tbl_name>','19-DEC-09
11.00.00.000000000 AM -04:00'); <--Insert the time you would like to revert
to.
If it's available, you will revert to those stats...
Hope this helps...
Kellyn Pedersen
Sr. Database Administrator
http://www.linkedin.com/in/kellynpedersen
www.dbakevlar.com
________________________________
From: Michael McMullen <ganstadba@xxxxxxxxxxx>
To: cemail_219@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Sent: Wed, November 10, 2010 9:43:45 AM
Subject: RE: Stats 10g
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:
