How long is the query time of "Oracle db_exporter"? How to set it up or down?

[hanhan579]

Hello! My "oracledb_export" query always times out. I use binary files. There are only "default-metrics.toml" and "oracledb_exporter". How can I set the query time? How many seconds is the default query timeout? @iamseth @Yannig @vvelikodny @pango853 @neilschelly @

[richardcrist]

@hanhan579 There is run time parameter query.timeout that you can use. Below is example where I use it to set timeout to 60 seconds. Also you can specify specific set of SQL queries using default.metrics or custom.metrics runtime parameter to specify a toml file.

/apps/oracledbexporter/oracledb_exporter/oracledb_exporter --log.level error --default.metrics /apps/oracledbexporter/oracledb_exporter/runopsmon_synprd4.toml --query.timeout 60 --web.telemetry-path /metrics --web.listen-address 0.0.0.0:9166

[hanhan579]

@hanhan579您可以使用运行时参数 query.timeout。下面是我使用它将超时设置为 60 秒的示例。您还可以使用 default.metrics 或 custom.metrics 运行时参数指定特定的 SQL 查询集以指定 toml 文件。

/apps/oracledbexporter/oracledb_exporter/oracledb_exporter --log.level 错误 --default.metrics /apps/oracledbexporter/oracledb_exporter/runopsmon_synprd4.toml --query.timeout 60 --web.telemetry-path /metrics --web.listen-地址 0.0.0.0:9166

OK, thank you. I've solved my problem