Alex, Although not specified, the TIME_WAITED in V$ACTIVE_SESSION_HISTORY is in Microseconds. Try this SQL out - shows up session events that took a second or more (and indirectly shows that TIME_WAITED is micro seconds). select sample_time, session_id|| ','|| session_serial# ses_sid, session_state, event, seq#, p1,p2,p3, wait_class, wait_time, round(time_waited/1000000) time_waited_sec, blocking_session_status from v$active_session_history where round(time_waited/1000000) > 0 order by session_id, sample_time; Other views specifically have this named as "TIME_WAITED_MICRO" (Metrics and System/Session Event views) so there is no confusion but this is not true for this core ASH view :( -- John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) Co-Author: Oracle Database 10g Insider Solutions http://www.amazon.com/gp/product/0672327910/ ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- //www.freelists.org/webpage/oracle-l