iamseth / oracledb_exporter

Prometheus Oracle database exporter.
MIT License
472 stars 242 forks source link

Some sql queries are taking time to execute, cause of which none of the queries are scraping data in time. #413

Open raspriyasharma opened 4 months ago

raspriyasharma commented 4 months ago

I'm submitting a ...

issue:

What is the current behavior?

I have 22 metrices in my toml file in which most of them have the execution time of 1-2 seconds but 2 of the queries are taking around 30-40 seconds. Because of this when I'm accessing the port it keeps on loading and after some time when completed, I'm getting an error for those 2 sqls that Nometricsfoundwhileparsing=(MISSING).

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem

What is the expected behavior?

Maybe you can provide an environment variable on how often it should access database. The default time interval is 0s in your code. As for some queries I don't want continuous data to show and some interval will be fine.

What is the motivation / use case for changing the behavior?

Please tell us about your environment:

My server is hosted on my companies server and protocol SSH version. I am using docker.

Version: X.Y.Z