Re: BLOB reading is slow

"kuon" <kuon_at_goyman.com> wrote:

...
> PARSE #9:c=0,e=3249,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=649035954850
> BINDS #9:
> EXEC #9:c=0,e=245,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=649035956128
> WAIT #9: nam='SQL*Net message to client' ela= 5 driver id=1952673792
> #bytes=1 p3=0 obj#=49584 tim=649035956247
> WAIT #9: nam='SQL*Net message from client' ela= 1189 driver
> id=1952673792 #bytes=1 p3=0 obj#=49584 tim=649035957670
> WAIT #9: nam='SQL*Net message to client' ela= 2 driver id=1952673792
> #bytes=1 p3=0 obj#=49584 tim=649035957968
> FETCH #9:c=0,e=166,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,tim=649035958028
> ... (many many many of those wait)

The above are mostly irrelevant preliminaries. You cut it off just where things start to get interesting. Obviously you can't post the entire thing here, but you should take a cut from the middle, where the slowness is happening.

Earlier you reported "SQL*Net more data to client" was the problem, but you didn't include any examples of those waits in your trace excerpt.

Is the time spread out pretty much equally among the SQL*Net waits, or are most of them very fast (low value for e=<number>) with a few very long ones?

Xho

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