Datafile sizing

From: Biddell, Ian <ian.biddell_at_hp.com>
Date: Thu, 24 Jul 2003 14:37:02 +1000
Message-Id: <25998.339299@fatcity.com>

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? Received on Wed Jul 23 2003 - 23:37:02 CDT