RE: Datafile sizing

Sorry I was still setting it all up, the datafiles will be numbered 1 thru 5 :-)
I was more concerned if I should add the bitmap header overhead to each datafile or just the first one.

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Thursday, 24 July 2003 11:49 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Datafile sizing

You'll want to modify your statement first to have different file names for each datafile. Just pointing it out in case the obvious was overlooked...

BTW, anyone know what that statement would do? Would it error out? Gotta get another playground for testing...

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Biddell, Ian [mailto:ian.biddell_at_hp.com]
> Sent: Thursday, July 24, 2003 12:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Datafile sizing
>
>
> 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: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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