Re: Interpreting DBA_HIST_SQLSTAT - 11g

Hi Cam,
If you are troubleshooting undo - snapshot too old errors check out this
link http://www.oraclenerd.com/2009/11/undo-brain-damage.html

for the view dba_hist_sqlstat, I've got two tiddlers under
http://karlarao.tiddlyspot.com/#DBA_HIST_SQLSTAT with some references and
test cases.
--> this tiddler http://karlarao.tiddlyspot.com/#SQLsRunInAnyPeriod explains
my objective on writing the script awr_topsqlx.sql
--> and this tiddler
http://karlarao.tiddlyspot.com/#MissingSQLinDBA_HIST_SQLSTAT has got some
references and test cases

and check out this blog by Craig
http://shallahamer-orapub.blogspot.com/2011/01/when-is-vsqlstats-refreshed.html



-- 
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com


--
http://www.freelists.org/webpage/oracle-l


Other related posts: