RE: Average Wait and Time Waited in Sessions view

Hi Matt,

  Are you looking at Session Browser -> RHS -> Waits?

  If so, we are just showing the data from Oracle.  We aren't doing anything to change the units (or even display them).  That data comes from the v$session_event view, and according to 11g Oracle docs, the time_waited column is microseconds.

http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3020.htm


-John


From: [email protected] [mailto:[email protected]] On Behalf Of Matt Birchall
Sent: Thursday, February 09, 2012 4:20 AM
To: [email protected]
Subject: [toad] Average Wait and Time Waited in Sessions view



Message from: Matt Birchall


I've been looking at the disk latency in our system and have looked at the time vs disk read values shown in SGA trace and in the Sessions view.
The Time waited and Average wait columns in the Total Waits breakdown of the Waits tab of the sessions view is a factor 10 lower than reality. The result is that my disks show an impressive 0.89 ms latency when, in reality, the value is 8.9 ms. The time waited micro is correct but the Time Waited column (presumably milliseconds?) and the Average Wait are 10X too small.
(Toad for Oracle Base 11.0.0.116)


_______________________________________

Historical Messages


Author: Matt Birchall
Date: Thu Feb 09 02:19:53 PST 2012
I've been looking at the disk latency in our system and have looked at the time vs disk read values shown in SGA trace and in the Sessions view.
The Time waited and Average wait columns in the Total Waits breakdown of the Waits tab of the sessions view is a factor 10 lower than reality. The result is that my disks show an impressive 0.89 ms latency when, in reality, the value is 8.9 ms. The time waited micro is correct but the Time Waited column (presumably milliseconds?) and the Average Wait are 10X too small.
(Toad for Oracle Base 11.0.0.116)

__
_______________________________________