Hi I wonder if anyone know how to obtain top activity in percentage using SQL as viewed from Enterprise Manager as explained in http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/img/top_activity_new.gif http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/img_text/top_activity_new.htm I believe it gathers the data from v$active_session_history using 5 minutes as time deltas? Thanks a lot -- LSC -- //www.freelists.org/webpage/oracle-l