Re: EM12c tx/s metric values drastically changed in 12.1.0.8 DB plugin?

On Wed, Mar 9, 2016 at 11:22 PM, Rich J <rjoralist3_at_society.servebeer.com> wrote:

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

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