Re: Interpreting DBA_HIST_SQLSTAT - 11g

From: Karl Arao <karlarao_at_gmail.com>
Date: Wed, 16 May 2012 11:29:22 -0500
Message-ID: <CACNsJnedxY47qzd6Z0256Ei9GC0CV_s_2t51e-15RL-Hf0vnyw_at_mail.gmail.com>

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 Received on Wed May 16 2012 - 11:29:22 CDT