bitmaps are stored within the datafiles themselves. You would add the
extra space to EACH datafile.
Tablespaces are logical constructs.... they have no physical reality
other than the corresponding datafiles.
If the bitmap were stored in only the first datafile, Oracle would need
to access that datafile header for EVERY space allocation in the
tablespace. Which would introduce the contention and performance hit
that LMTs are meant to reduce
- "Biddell, Ian" <ian.biddell_at_hp.com> wrote:
> Hi All,
>
> I have seen previous discussions on datafile sizing and adding 64k to
> the size for the bitmap header.
> Also other people saying that they just go for 2001MB when they want
> a
> 2000mb datafile.
> My question is does each datafile require this within the tablespace
> or
> is it just one per tablespace to facilitate LMT ?
>
> So if I have this statement
> CREATE TABLESPACE csis_l_tables LOGGING
> DATAFILE 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M,
> 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M,
> 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M,
> 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 8000M,
> 'D:\oracle\oradata\gcdev\tables_l01.dbf' SIZE 4000M
>
> extent management local uniform size 64m SEGMENT SPACE
> MANAGEMENT AUTO;
>
> Do I add 1mb to each datafile or just the first?
>
> Thanks
> Ian
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Biddell, Ian
> INET: ian.biddell_at_hp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Received on Thu Jul 24 2003 - 04:53:12 CDT
