Re: Another datafile sizing question

From: Thomas Day <tday6_at_csc.com>
Date: Thu, 26 Sep 2002 19:28:20 -0800
Message-ID: <F001.004DAB47.20020926192820@fatcity.com>

Is the requirement that all datafiles be the same size a business requirement?

I guess that having all datafiles the same size would be useful if you need to move them to other platters. Do you have multiple physical devices to move your datafiles around in?

If you only have a single RAID device then there's no point in moving datafiles from one logical device to another (since it's all one physical device). Therefore I'm not sure that there's much point in keeping datafiles the same size.

                                                                                                                   
                    "Browett,                                                                                      
                    Darren"              To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <dbrowett            cc:                                                                       
                    @city.coquitl        Subject:     Another datafile sizing question                             
                    am.bc.ca>                                                                                      
                    Sent by: root                                                                                  
                                                                                                                   
                                                                                                                   
                    09/25/2002                                                                                     
                    07:43 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L

I am in the process of upgrading our databases from 8.0.5 to 8.1.7, possibly 9i depending on application
certifications.

I currently have a tablespace that is made up of 4 - 200mb datafiles, my first thought would be to
create a 800mb datafile and move all the data into it,

The growth of this tablespace is maybe 100 to 150Mb a year, and from what I understand all datafiles should
be the same size. So at that point when I need another datafile, I will have to create another 800Mb datafile.

Would that be a good practise, or should I stay with multiple 200/300/400/500 etc 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 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 command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Thomas Day
INET: tday6_at_csc.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