Re: Where LMT bitmaps are added when you have zillions of extents ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 5 Dec 2005 14:30:16 +0000 (UTC)
Message-ID: <dn1ito$649$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com>

"Spendius" <spendius_at_muchomail.com> wrote in message news:1133792553.949848.151410_at_g49g2000cwa.googlegroups.com...
> Suppose you have a datafile in an LMT tablespace with so many extents
> that Oracle
> no more has the room to update its bitmap locator: where is the new
> bitmap extent
> created ?
>
> Thanks.
>

This should only happen if the data file has extended, and I believe that as soon as the file extends past the scope of the current bitmap, that is the point at which the next bitmap will be created.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 29th Nov 2005

Received on Mon Dec 05 2005 - 08:30:16 CST