Takes 5+min to launch the tool

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

Takes 5+min to launch the tool #39

Closed raghavtech closed 3 years ago

raghavtech commented 3 years ago

the tool seem to pull the last 60min data from ash and becomes extremely slow to launch under load as it tries to load last 60min data.

can we get an option to load ash data start from the point of launch/click connect to database.

if the database is under heavy load from users. it takes large amount of time to start up

akardapolov commented 3 years ago

Hi!

It's true for heavy loaded database (hundreds connections per second). You can use OracleSE mode while loading long running profile. It takes data from the point of launch.

Thanks, Alex.