RE: AWR - DB Time by User Trend Report?
- From: "Lei Zeng" <lzeng@xxxxxxxxxxxxx>
- To: <jeffthomas24@xxxxxxxxx>, "ORACLE-L" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 9 Sep 2009 18:37:29 -0700
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
