-
Notifications
You must be signed in to change notification settings - Fork 1.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Oracle Integration is missing System Metrics #16574
Comments
Got an update on this one: However, the official instructions to set up a The create view v_x$ksuse as select * from x$ksuse;
create view v_x$kslwt as select * from x$kslwt;
create view v_x$ksled as select * from x$ksled;
create synonym datadog.v_x$ksuse for v_x$ksuse;
create synonym datadog.v_x$kslwt for v_x$kslwt;
create synonym datadog.v_x$ksled for v_x$ksled; and then create the FROM
v_x$ksuse s,
v_x$kslwt w,
v_x$ksled e,
v$sql sq,
v$sql sq_prev,
v$containers c,
v$sqlcommand comm
WHERE Then, the |
Issue observed
After installing the Oracle Integration, we do receive data from the instance via the Agent and the reported metrics are shown in the Datadog-provided "DBM Oracle Database Overview"-Dashboard:
However, we're missing data in these reports, as the dashboards show that some metrics are missing. In fact, the integration does query DBMS statistics, but does not report all of them back to the agent:
https://github.com/DataDog/integrations-core/blob/master/oracle/datadog_checks/oracle/queries.py#L19
For example, the very important metric
User Transaction Per Sec
is not used by the integration.Our Oracle database can report the following metrics via
GV$SYSMETRIC
:It's probably easy to incorporate the additional metrics into the reporting.
Output of the info page
Note: Our Agent in Kubernetes can't execute
s6-svstat
:s6-svstat: command not found
Additional environment details (Operating System, Cloud provider, etc):
We're running Agent (v7.50.2) in Azure Kubernetes, installed via Helm (Chart v3.50.2).
We're using Oracle 19 for our RDBMS.
Steps to reproduce the issue:
Describe the results you received:
The Oracle integration reports a few metrics
Describe the results you expected:
The Oracle integration reports all metrics.
Additional information you deem important (e.g. issue happens only occasionally):
The text was updated successfully, but these errors were encountered: