Re:[Fwd: Re: 10046 trace - unaccounted for time]

From: Keith Moore <>
Date: Thu, 7 Aug 2008 12:54:28 -0500 (CDT)
Message-ID: <>

Thanks. We have confirmed it is some type of LOB index corruption.

Insert to BLOB stored inline works fine. Insert to BLOB stored out of line (one row, 5MB blob) takes 4 minutes Insert to BLOB stored out of line (new copy of table) takes 0.125 seconds.

We are now rebuilding table.

Thanks to everyone for their help.


> There is known bug on certain version when lots of rows deleted, insert took
> ling time either waiting for hw enqueue or lots of time searching lob index to
> find right place to insert...
> Sent via BlackBerry by AT&T

Received on Thu Aug 07 2008 - 12:54:28 CDT

Original text of this message