Re:[Fwd: Re: 10046 trace - unaccounted for time]
Date: Thu, 7 Aug 2008 12:54:28 -0500 (CDT)
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