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

  • From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
  • To: kmoore@xxxxxxxxxxxx
  • 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.
> Keith


Other related posts: