Hi team, app is great but take too much long time in open when you try in Oracle RAC with too many records in the v$active_session_history.

I try to increase java memory to 8Gb (java.exe -Xmx8096m -jar ASH-Viewer.jar) but not helps.

Can you add and option to start the app reading only 5 minutes of data.
I find 2 sql when you load the data (OracleEE.java and OracleEEObject.java )
can you generate a version to start the app loading only 5 minutes of data (or N in a parameter)

In OracleEEObject.java
change
String sqlTextAsh = "select a., b.object_name, b.object_type, subobject_name "
+ "from v$active_session_history a, all_objects b where a.current_obj# = b.object_id(+)";
for
String sqlTextAsh = "select a., b.object_name, b.object_type, subobject_name "
+ "from v$active_session_history a, all_objects b where a.current_obj# = b.object_id(+) "
+ "and a.sample_time <= sysdate - interval '5' minute";

In OracleEE.java
change
String sqlTextAsh = "SELECT * FROM v$active_session_history";
for
String sqlTextAsh = "SELECT * FROM v$active_session_history where sample_time <= sysdate - interval '5' minute";