Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: datafile sizing ?

RE: datafile sizing ?

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Thu, 18 Apr 2002 08:53:32 -0800
Message-ID: <F001.00448245.20020418085332@fatcity.com>


Hello Darren,ROR and all,

How about using locally managed tablespaces and allocating uniform extent size ( say 4M ) , when we create a tablespace with multiple small datafiles ( say 500 M ) ????

I would prefer to have a standard for the size of the datafile .

--Madhu

-----Original Message-----
Sent: Thursday, April 18, 2002 7:23 AM
To: Multiple recipients of list ORACLE-L

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
>
>
>
>



> --
> ----------------------------------------------
> Darren Browett P.Eng

                                                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: Browett, Darren
> INET: dbrowett_at_city.coquitlam.bc.ca
>
> 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: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reddy, Madhusudana
  INET: Madhusudana.Reddy_at_bestbuy.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).
Received on Thu Apr 18 2002 - 11:53:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US