Re: ASSM tablespace three level bmp block questions.

From: lsllcm <lsllcm_at_gmail.com>
Date: Thu, 2 Apr 2009 18:24:33 -0700 (PDT)
Message-ID: <aa6d3335-1354-4b4e-a76d-7432023f5f2d_at_x1g2000prh.googlegroups.com>

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.

Thanks
Jacky Received on Thu Apr 02 2009 - 20:24:33 CDT