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.
Keith
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
