Re: BLOB reading is slow

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Nov 2005 05:02:28 GMT
Message-Id: <pan.2005.11.15.05.02.27.853181@sbcglobal.net>

On Mon, 14 Nov 2005 22:30:50 +0100, Sybrand Bakker wrote:

> It does. You didn't set SDU (it's still at 2048), as I recommended to
> you several times.

And he didn't buy a Powerball ticket, either. It has as much to do with the problem as SDU. Sybrand, your advice is usually priceless, except when it's drivel, like in this case. He is spending time in the client. His largest wait is the following:

"WAIT #0: nam='SQL*Net message from client' ela= 8006447 driver"

His client is spending 8 seconds to send the data. What's SDU got to do with it? Fortunately, your pleasant and charming personality makes even this advice useful....for Monty Python lovers.

-- 
http://www.mgogala.com

Received on Mon Nov 14 2005 - 23:02:28 CST