search

iamseth / oracledb_exporter

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

Requesting queries with different execution intervals #415

Open benbkim opened 4 months ago

benbkim commented 4 months ago

I'm submitting a ...

What is the current behavior?

We would like to run queries with different execution times. For example, the query that checks table space fullness doesn’t need to run frequently. However, queries checks lock or app session info needs to run more frequently. I don’t see a way of running queries with different execution intervals. It seems all queries are running with the same execution intervals.

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?

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

Some queries do not need to run as frequently as others.

Please tell us about your environment:

We are using the latest Oracle Prometheus on Oracle 19c Version: X.Y.Z

benbkim commented 4 months ago

It would be very helpful to have this feature. Thank you.

Pawel-Gosek commented 2 weeks ago

I had the same issue and as a workaround I'm adding time constraints to some queries, like: "and (to_char(sysdate,'HH24')=10 and to_char(sysdate,'MI')<20)" Depending on your needs this could be doable this way.