AWR - DB Time by User Trend Report?

  • From: Jeffery Thomas <jeffthomas24@xxxxxxxxx>
  • To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 9 Sep 2009 21:13:41 -0400

Hello all -

I'm composing a few historical reports from the AWR, using this link as a guide:

http://www.oracle.com/technology/products/manageability/database/pdf/owp_awr_historical_analysis.pdf

One report I'm trying to develop is a "DB Time by User" trend report -
if at all practical - but I'm having
difficulty determining which DBA_HIST* tables are relevant with
respect to aggregating by the user.

Would anyone a similar report or  at least, what tables may contain
the necessary information?

Thanks -
Jeff
--
//www.freelists.org/webpage/oracle-l


Other related posts: