Re: time_waited unit in v$active_session_history
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Thu, 3 May 2007 15:43:36 -0700
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
Other related posts:
