Re:[Fwd: Re: 10046 trace - unaccounted for time]
Date: Thu, 7 Aug 2008 13:49:34 -0500 (CDT)
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.