Re: ASSM tablespace three level bmp block questions.

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 02 Apr 2009 22:45:24 -0500
Message-ID: <qEfBl.23689$Ws1.19435_at_nlpi064.nbdc.sbc.com>



lsllcm wrote:
> On Apr 2, 4:05 pm, Randolf Geist <mah..._at_web.de> wrote:

>> On Apr 1, 1:10 pm,lsllcm<lsl..._at_gmail.com> wrote:
>>
>>> Thanks for the document, but I still cannot find the answer from the
>>> document
>> Jacky,
>>
>> Tanel Poder has done a quite detailed explanation and comparison of
>> ASSM and freelist management, although it's already a bit outdated I
>> think the key aspects are still applicable to the latest Oracle
>> versions, and it might cover some of your detailed questions:
>>
>> <a href="http://perfvision.com/docs/
>> Poder_Freelists_vs_ASSM.ppt">Freelists vs. ASSM presentation</a>
>>
>> Regards,
>> Randolf
>>
>> Oracle related stuff blog:http://oracle-randolf.blogspot.com/
>>
>> SQLTools++ for Oracle (Open source Oracle GUI for Windows):http://www.sqltools-plusplus.org:7676/http://sourceforge.net/projects/sqlt-pp/
> 
> I also read this document, in the document, it states that Level 1 BMP
> block has 64 - 1024 DBA range.
> 

I believe it also stated that this was the observed behavior and not actually from any valid Oracle documentation on the subject.

> Thanks
> Jacky Received on Thu Apr 02 2009 - 22:45:24 CDT

Original text of this message