Re: time_waited unit in v$active_session_history

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 **
--
http://www.freelists.org/webpage/oracle-l