Time waited in v$session_event is inflated
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 27 Jul 2009 12:10:52 -0400
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@orat>l ( mailto:JBECKSTROM@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@orat>@sess_events ( mailto:JBECKSTROM@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@orat>
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
Other related posts:
