FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 27, '09 at 4:10p
activeJul 27, '09 at 4:10p
posts1
users1
websiteoracle.com

1 user in discussion

Jeffrey Beckstrom: 1 post

People

Translate

site design / logo © 2022 Grokbase