RE: AWR - DB Time by User Trend Report?

Select value
from DBA_HIST_SYS_TIME_MODEL
where stat_name='DB time'

Thanks,
Lei Zeng
Sr. Oracle DBA
Yahoo
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffery Thomas
Sent: Wednesday, September 09, 2009 6:14 PM
To: ORACLE-L
Subject: AWR - DB Time by User Trend Report?

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-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: