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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
