Re: What use is OCP? they did it again!

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<175D9.81280$g9.228852_at_newsfeeds.bigpond.com>...
> "mario" <mario_jvn_at_yahoo.it> wrote in message
> news:b84ce0d2.0211200929.85ed698_at_posting.google.com...
>
> Hi Mario,
>
> Actually you are both right.
>
> If a LMT has a uniform size, then yes, all bits correspond to an extent (as
> all extents must be of the same size)
>
> However, if the LMT is autoallocate, then it can have a number of difference
> extent sizes, when can appear anywhere within the tablespace. Therefore in
> this case, each bit does indeed correspond to a block and Oracle searches
> for a range of bits that corresponds to the required extent size. It makes
> the bitmap less efficient as a result but you can still fit a mamma of a lot
> of bits in the bitmaps initially allocated.
>
> All that said, answer B may or may not be correct and it's an ambiguity
> that's makes the question a bit stinky.
>
> Cheers
>
> Richard

Many thanks Richard,

 I didn't remeber the 'autoallocation' clause ( the reason of the oversight is that I never use 'AUTOALLOCATION', it makes a mess during administration ).
 Anyway the ambiguity of the questions it is almost unforgivable, especially because they come from OCP's director :-)

thanks again Richard

Mario from Rome. Received on Thu Nov 21 2002 - 14:54:48 CST