Skip to content
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

fix the config file of oracledb dashboard #40

Closed
r-deguchi opened this issue Nov 14, 2023 · 6 comments
Closed

fix the config file of oracledb dashboard #40

r-deguchi opened this issue Nov 14, 2023 · 6 comments
Assignees

Comments

@r-deguchi
Copy link

I found a mistake in 3333_rev1.json.
The query for active sessions is written as follows,

"expr": "oracledb_sessions_active{instance=\"$host\"}"

but I think it is correctly written as follows.

"expr": "oracledb_sessions_value{instance=\"$host\", status=\"ACTIVE\", type=\"USER\"}"

This worked correctly for me.

@markxnelson
Copy link
Member

Thank you for reporting the issue, I will take a look and update it.

@markxnelson
Copy link
Member

We had a look at this suggestion, and we agree with your suggestion for status=ACTIVE. For the type, our thinking is that people might want to see things like jobs that run from time to time and so consume sessions too.

@markxnelson markxnelson self-assigned this Nov 14, 2023
@r-deguchi
Copy link
Author

r-deguchi commented Nov 15, 2023

Yes, it may not be necessary to limit it to users.

The problem is the metric "oracledb_sessions_active" does not exist, so it shows no data on Grafana.
I fixed it to "oracledb_sessions_value" and it worked.

@markxnelson
Copy link
Member

Great, thank you again. I will make this change tomorrow.

@markxnelson
Copy link
Member

pushed the change in #42

@markxnelson
Copy link
Member

closing this issue now, please feel free to reopen it if needed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants