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 72 forks source link

History data not working properly #22

Open avtaritet opened 5 years ago

avtaritet commented 5 years ago

Hi, i have a couple of questions? 1.when i am checking in ash-viewer history button. when i tried to pull week data it is not returning weekly data. it is just returning 1 day data. other days are empty. Even 1 days data is not full couple of hours it is showing

  1. Is there any way you can include more historical data 1 month data or 2 month data in the history list?
  2. When trying to connect Rac databases and using scan address with service_name it is not working. You have to mention Sid only. Could you please add this option also?
avtaritet commented 5 years ago

now in the new edition(v4.2.1) it shows properly for history data. But top activity shows only for last 1 hour. if you choose 3-4 hours back you cannot see any top activity data. is it possible you can add DBA_HIST_ACTIVE_SESS_HISTORY also? For it is better than oem because it works fast than oem. and Also supports postgres also. Great job Thanks a lot