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

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

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

--
http://www.freelists.org/webpage/oracle-l