cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle Insights v2 API CPU values interpretation

louis_gallo
Helper

We are experimenting with the CPU numbers for Oracle servers coming back from Oracle Insights both in the UI and v2 API. The numbers that we are getting back are wildly high. 

Here is a sample query:

 

DEBUG:root:Composing the initial Dynatrace V2 API get metrics call - https://xxxxxxxx.live.dynatrace.com/api/v2/metrics/query?metricSelector=builtin%3Atech.oracleDb.cd.cpu.%28background,foreground%29%3Anames%3Amerge%28dt.entity.custom_device%29&from=2022-01-28T11%3A00%3A00-05%3A00&to=2022-01-28T12%3A40%3A00-05%3A00&entitySelector=type%28%22CUSTOM_DEVICE%22%29%2Ctag%28server:xxxxxxxxxxxx%29&resolution=1m 

 

QUESTION 1 - Sometimes we see values coming back for CPU in the thousands of %. Why is that? Should we be using both background and foregroung CPU per database?

 

QUESTION 2 - If Oracle insights is only collecting data at 5 or 10 minute intervals, how does that equate into the data as it is displayed in the UI or pulled via the API, especially if Dynatrace is delivering back 1-minute data.

 

Any advice on how this metric should be interpreted or handled would be appreciated.

 

Thanks,

 

Lou

1 REPLY 1

dglugla
Dynatrace Pro
Dynatrace Pro

Hey @louis_gallo 

High CPU usage and spikes reported for that metric can be caused by many different reasons, like e.g. CPU provisioning. It's really hard to tell the reason without investigating the case directly in the database, and we would still need to rely on your DBA's assistance.

Foreground and background CPU usage have different meanings, and I'm not able to answer your question not knowing what problem you're trying to solve, or what do you need this data for.

Oracle DB Insights collects data in 1 minute intervals. Only query statistics and wait states are collected in 5 minute intervals, as those queries consume more resources.

 

Keep in mind that any improvements we may come up with will only be implemented in the Oracle DB extension, not the DB Insights.

 

Kind regards, Darek

Empower Enterprise Apps and Services monitoring in Dynatrace

Featured Posts