Hi everyone!
I am struggling with two metrics in DT Managed. I looked around the threads but couldn't find something related to my issue. 
So, here's what I am trying to understand. We installed an OracleDB extension in DT to monitor the performance of our DBs. In the metrics that we get from the extension I see the following two:
com.dynatrace.extension.sql-oracle.cpu.backgroundTotal
com.dynatrace.extension.sql-oracle.cpu.foregroundTotal
They show a number of the Foreground/Background CPU Usage/per second. It didn't mean anything to me (probably because I know almost nothing about DBs). So I checked it up and it seems the dimention of this value is CPU usage of foreground/background processes in centi seconds per second...😮
I hope it doesn't sound (too) stupid but as far as I know we have 100 centi seconds in a second, while the number shown by these metrics is in the range of 500-600-700 (of course constantly changing).
Can someone explain to me what it actually means?
Also, the other fun part is that the DB team who will use these data for performance analysis wants to see this CPU usage in % and not this strange value. Is there a similar metric that I can use or a way to aggregate it from this one? I assume it wouldn't be sufficient to have only the host CPU usage.
Thanks a lot to everyone who will ease my pain!
All the best,
Georgi
Featured Posts
