Re: BLOB reading is slow

"kuon" <kuon_at_goyman.com> wrote:
> 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

From your database's perspective, it spent less than one millisecond sending 32kb of data to your client, and then spent 8 seconds waiting for your client to get its act together and make its next request.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB