| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: datafile sizing ?
Darren,
It also depends on the extent sizes you use for the tables in the
tablespace. Will each extent completely use the datafile or will there
be wasted space in the smaller datafiles. As an example: if there is 100
M free space and the extent is 150 M it will not fit in the datafile and
will use the next free space in the new datafile, wasting the 100 M free
space. That can add up to a lot of space over time.
Also remember to set the MAXDATAFILE to a limit allowable by the os.
once you reach the limit if it is set small you have to rebuild the
database to raise the limit. Different os's have different limits.
Ron
ROR mª¿ªm
>>> lisa.koivu_at_efairfield.com 04/17/02 08:34PM >>>
Darren, discuss this with your SA. There may be a limit on the os side
you
need to be aware of.
Also, consider MTTR. Seems to me that MTTR won't be that different
between
a 500MB file and a 2GB file.
Beyond that, it's your comfort level. Personally I like having larger
files
for ease of administration.
Lisa Koivu
Oracle Database Monkey Mama
Fairfield Resorts, Inc.
954-935-4117
> -----Original Message-----
> From: Browett, Darren [SMTP:dbrowett_at_city.coquitlam.bc.ca]
> Sent: Wednesday, April 17, 2002 5:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: datafile sizing ?
>
> I am currently building a new 8i database, and have the oppurtunity
to
> consolidate
> some of my datafiles. In the current configuration I have 4 500Mb
> datafiles
> that make up
> a tablespace.
>
> Is it okay to create a 2Gb datafile, or am I better off to create 2
1Gb
> datafile's, or
> stay with 4 500Mb datafiles.
>
> Thanks
>
> Darren
>
>
>
>
This
message
> was transmitted
> Data Administrator using
100%
> recycled electrons
> Information and Communication Technology
> City of Coquitlam
> P:(604)927 - 3614
> E:dbrowett_at_city.coquitlam.bc.ca
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: lisa.koivu_at_efairfield.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Thu Apr 18 2002 - 07:23:19 CDT
 |
 |