Time waited in v$session_event is inflated

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 27 Jul 2009 12:10:52 -0400
Message-Id: <4A6D994A.3406.000B.0_at_gcrta.org>

Running the below SQL shows time for SQL Net Message from client that is greater than the time the session has been connected. This is 10.2.0.4 with patch 18 on Windows X64 hardware.  

Anyone else see this?  

JBECKSTROM_at_orat>l ( mailto:JBECKSTROM_at_orat> )   1 select sess_ev.*,
  2 time_waited_micro/1000000 time_waited_in_sec   3 from v$session_event sess_ev
  4 where sid=&1
  5* order by time_waited
JBECKSTROM_at_orat>_at_sess_events ( mailto:JBECKSTROM_at_orat> )38 old 4: where sid=&1
new 4: where sid=38  

       SID EVENT                     TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
---------- ------------------------- ----------- -------------- -----------

AVERAGE_WAIT MAX_WAIT TIME_WAITED_MICRO EVENT_ID WAIT_CLASS_ID WAIT_CLASS#

------------ ---------- ----------------- ---------- ------------- -----------

WAIT_CLASS

---

TIME_WAITED_IN_SEC

---

        38 SQL*Net message to client        1663              0           0
           0          0              2273 2067390145    2000153315           7
Network


           .002273

 
        38 latch: library cache               26              0           0
           0          0               237  589947255    3875070507           4
Concurrency


           .000237

 
        38 SQL*Net more data to clie          70              0           1
           nt
         .01          0              5811  554161347    2000153315           7
Network


           .005811

 
        38 db file sequential read           228              0     6686619
    29327.28     342260        6.6866E+10 2652584166    1740759767           8
User I/O
        66866.1887
 
        38 SQL*Net message from clie        1662              0    22671361
           nt
    13641.01     359978        2.2671E+11 1421975091    2723168908           6
Idle
        226713.608
 

JBECKSTROM_at_orat>    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 27 2009 - 11:10:52 CDT