On Fri, Jan 14, 2011 at 8:04 PM, John Kanagaraj <john.kanagaraj@xxxxxxxxx>wrote: > Hi Dave, > > > If you wanted to dive into the guts of the AWR report you could always > > use the API to generate an AWR report and trace it to see what SQL it > > is issuing. > > Based on the fact that the STATSPACK report for a particular version > (starting from 10g) matches the AWR report at least at the section > level, a better option is to read the source code from the > corresponding STATSPACK code. Go to $ORACLE_HOME/rdbms/admin and > browse the sprepins.sql and spcpkg.sql files. They will have the SQL > in plain view - replacing STATS$ by DBA_HIST_ should do the trick > > Neat trick, thanks John. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com