Hey all,
I'm running some EM12c (12.1.0.5) queries, including this one to capture
tx/s from one target:
SELECT
rollup_timestamp ROLLUP,
average,
minimum,
maximum
FROM sysman.mgmt$metric_daily
WHERE target_name = 'proddb'
AND target_type = 'oracle_database'
AND metric_name = 'instance_throughput'
AND metric_label = 'Throughput'
and column_label = 'Number of Transactions (per second)'
AND rollup_timestamp > TO_DATE('20160131','yyyymmdd')
ORDER BY column_label, rollup_timestamp;
Here's a snip of the output, around 2016/02/10, which is the date I
upgraded the target's agent from 12.1.0.3 to 12.1.0.5:
ROLLUP AVERAGE MINIMUM MAXIMUM
02/01/2016 168.256176570621 0.101402737873923 1011.68550531915
02/02/2016 159.27293514599 0.365569956796278 1223.6124958458
02/03/2016 155.587635957881 0.099684332945672 1171.24028387969
02/04/2016 165.356192812093 0.84545147108556 1082.17015619807
02/05/2016 157.452399369274 0.781379883624273 1130.89066134929
02/06/2016 146.536982406772 0.33206043499917 1043.66688829787
02/07/2016 220.803826449815 0.133958472873409 1375.24505731849
02/08/2016 169.858874365762 0.132890365448505 1084.77646667775
02/09/2016 167.565083420313 0.79773973741067 1082.12030574942
02/10/2016 167.715875451865 0.995 1029.21721788267
02/11/2016 60.8731038961039 0.015 976.601
02/12/2016 78.4151428571428 0.401 884.696
02/13/2016 70.3895342465753 0 795.576
02/14/2016 98.7350882352941 0.04 828.676
02/15/2016 80.8606197183099 0.04 674.624
02/16/2016 81.94853125 0.129 779.102
02/17/2016 71.2182933333333 0.127 648.601
Since we also had a new app deployment on that date, I was trying to
find out what awesome magic our Devs did, but as that doesn't appear to
be the case, I did some further digging. I ran the above against
MGMT$METRIC_HOURLY (yes, I have the retention set that high), and sure
enough the change started around 11:00, which is when I rolled out the
Agent upgrade. Since this rollout included v12.1.0.8 of the Oracle DB
Plugin, I've been trying to find a changelog on it, but not having any
luck. The readme from the plugin page in EM just generically states the
plugins function with no details on the version.
So, I'm guessing that I have tx/s values misstated somewhere, but not
sure where.
Thoughts, anyone?
Rich
