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

From: Keith Moore <>
Date: Thu, 7 Aug 2008 13:49:34 -0500 (CDT)
Message-ID: <>

Can anyone tell me whether moving the blob to a different tablespace will cause the index to be rebuilt. I know the index moves so it seems like it would need to be rebuilt but just wanted to confirm.


> 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.
> Keith

Received on Thu Aug 07 2008 - 13:49:34 CDT

Original text of this message