[BUG] default metric 'wait_time' fail with error ORA-00904: "TIME_WAITED_SEC_TOTAL": invalid identifier"

[romankspb]

Description

On some oracledb instances request wait_time from default-metrics.toml fail with error "ORA-00904: "TIME_WAITED_SEC_TOTAL": invalid identifier".

select
inst_id,
wait_class,
round(time_waited/100,3) time_waited_sec_total,
con_id
from gv$system_wait_class
where wait_class <> 'Idle'
group by inst_id, wait_class, con_id, time_waited_sec_total

Request below working everywhere

select
inst_id,
wait_class,
round(time_waited/100,3) time_waited_sec_total,
con_id
from gv$system_wait_class
where wait_class <> 'Idle'
group by inst_id, wait_class, con_id, round(time_waited/100,3)

Environment

• OS: official docker image
• Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.26.0.0.0
• Exporter version: 2.0.3, 2.0.4

[anders-swanson]

Thanks, looks like a straight-forward fix to work with 19c sql syntax. I'll push a fix for this shortly, and we'll include it in 2.0.5 release.

In the mean time, you can override the default metrics with your query that's valid for 19c.

[anders-swanson]

See the config file docs for clarification: https://oracle.github.io/oracle-db-appdev-monitoring/docs/configuration/config-file

# config file
metrics:
  default: my-custom-default-metrics.yaml