AWR - DB Time by User Trend Report?
From: Jeffery Thomas <jeffthomas24_at_gmail.com>
Date: Wed, 9 Sep 2009 21:13:41 -0400
Message-ID: <22131320909091813u482e1d24t8d0e38b344874211_at_mail.gmail.com>
Hello all -
Date: Wed, 9 Sep 2009 21:13:41 -0400
Message-ID: <22131320909091813u482e1d24t8d0e38b344874211_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 09 2009 - 20:13:41 CDT