Re: awr history

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: john.kanagaraj@xxxxxxxxx
  • Date: Sat, 15 Jan 2011 17:43:07 -0500

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:
Home Page:

Other related posts: