Hello,
I hope this data will speak more:
- 2005-11-14 20:05:04.492
WAIT #0: nam='SQL*Net message from client' ela= 8006447 driver
id=1952673792 #bytes=1 p3=0 obj#=49584 tim=97037326582
WAIT #0: nam='direct path read' ela= 286 file number=4 first dba=45628
block cnt=1 obj#=49584 tim=97037327721
WAIT #0: nam='SQL*Net message to client' ela= 3 driver id=1952673792
#bytes=1 p3=0 obj#=49584 tim=97037327813
WAIT #0: nam='SQL*Net more data to client' ela= 78 driver id=1952673792
#bytes=2049 p3=0 obj#=49584 tim=97037327930
WAIT #0: nam='SQL*Net more data to client' ela= 31 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037327999
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328049
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97037328096
WAIT #0: nam='direct path read' ela= 60 file number=4 first dba=45632
block cnt=1 obj#=49584 tim=97037328217
WAIT #0: nam='SQL*Net more data to client' ela= 18 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328303
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328351
WAIT #0: nam='SQL*Net more data to client' ela= 13 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328396
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97037328440
WAIT #0: nam='direct path read' ela= 2 file number=4 first dba=45636
block cnt=1 obj#=49584 tim=97037328471
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328542
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328588
WAIT #0: nam='SQL*Net more data to client' ela= 13 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328631
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97037328685
WAIT #0: nam='direct path read' ela= 3 file number=4 first dba=45640
block cnt=1 obj#=49584 tim=97037328718
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328789
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328835
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97037328879
WAIT #0: nam='SQL*Net more data to client' ela= 13 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97037328921
WAIT #0: nam='SQL*Net message from client' ela= 8006764 driver
id=1952673792 #bytes=1 p3=0 obj#=49584 tim=97045335826
WAIT #0: nam='direct path read' ela= 279 file number=4 first dba=45581
block cnt=1 obj#=49584 tim=97045336921
WAIT #0: nam='SQL*Net message to client' ela= 2 driver id=1952673792
#bytes=1 p3=0 obj#=49584 tim=97045337042
WAIT #0: nam='SQL*Net more data to client' ela= 152 driver
id=1952673792 #bytes=2049 p3=0 obj#=49584 tim=97045337234
WAIT #0: nam='SQL*Net more data to client' ela= 29 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337303
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337351
WAIT #0: nam='SQL*Net more data to client' ela= 13 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97045337397
WAIT #0: nam='direct path read' ela= 65 file number=4 first dba=45585
block cnt=1 obj#=49584 tim=97045337495
WAIT #0: nam='SQL*Net more data to client' ela= 18 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337581
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337629
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337675
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97045337732
WAIT #0: nam='direct path read' ela= 3 file number=4 first dba=45589
block cnt=1 obj#=49584 tim=97045337766
WAIT #0: nam='SQL*Net more data to client' ela= 15 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337838
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337885
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045337928
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97045337971
WAIT #0: nam='direct path read' ela= 39 file number=4 first dba=45593
block cnt=1 obj#=49584 tim=97045338038
WAIT #0: nam='SQL*Net more data to client' ela= 17 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045338117
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045338165
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2048 p3=0 obj#=49584 tim=97045338218
WAIT #0: nam='SQL*Net more data to client' ela= 14 driver id=1952673792
#bytes=2020 p3=0 obj#=49584 tim=97045338263
- 2005-11-14 20:05:20.895
I also found something while I was in EM,
(Under the session information Tab)
Last Call Elapsed Time 6 Seconds
Each time I got data on the client, this drop down to 0 seconds.
Then it grow up to 9 seconds, and again back to 0. (At this moment I
got data on my client machine)
Received on Mon Nov 14 2005 - 13:09:19 CST