search

akardapolov / ASH-Viewer

ASH Viewer provides a graphical view of active session history data within the Oracle and PostgreSQL DB
GNU General Public License v3.0
167 stars 73 forks source link

Incorrect display of values ​​along the y-axis in history for oracle. 4.3.1 #45

Open feagor opened 3 years ago

feagor commented 3 years ago

Hello, when I open history tab there is wrong display for active session count along the y-axis Expected about 60, actually 12. Also, there is no smooth in selected interval tab. I'm colored blank places where should be a data изображение изображение

feagor commented 3 years ago

As I understand these problems are related and appear when a selected period is not divide by 60 minutes without a remainder.

akardapolov commented 3 years ago

Hi!

It seems bug in chart. I've seen it too, but rarely. Have you raw data (ASH) from DB. What the right value of average active session history - 60 or 12?

Thanks, Alex.

feagor commented 3 years ago

Correct value - 60. It's correct for online Top Activity tab and screenshot

sbartek84 commented 3 years ago

Hi When can we expect the bug to be fixed ?

Thanks, Bartek

akardapolov commented 3 years ago

Hi!

Try the last release https://github.com/akardapolov/ASH-Viewer/releases/tag/4.3.3 with small fix https://github.com/akardapolov/ASH-Viewer/commit/0c5a504762dca14c621a23c7a666337b528f3176

Hope it helps.

Thanks, Alex.

sbartek84 commented 3 years ago

Hi!

Try the last release https://github.com/akardapolov/ASH-Viewer/releases/tag/4.3.3 with small fix 0c5a504

Hope it helps.

Thanks, Alex.

Hi Alex, I am using the latest version available.

View of active sessions image

View from session history image

Thanks, Bartek