Re: How can I get the BBED password?

Hi,

This is called block coalescing. If I recall correctly, Oracle only tries to coalesce a block if it sees that the block does have enough total free space for insert/update operation, but there is no contiguous free chunk big enough available. Also it might work the same way for expanding ITL area as well, but I havent tried it..

Tanel.

• Original Message ----- From: "Parker, Matthew" <matthewp_at_amazon.com> To: <AGUERRA_at_amfam.com>; "Christian Antognini" <Christian.Antognini_at_trivadis.com> Cc: <oracle-l_at_freelists.org> Sent: Wednesday, April 13, 2005 8:27 PM Subject: RE: How can I get the BBED password?

> Oracle does not always reorg the rows in a block. There are different =
> optimizations that oracle uses as to when certain internal block =
> manipulations are performed.=20
>
> -----Original Message-

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