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
<[EMAIL PROTECTED]>
<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:[EMAIL PROTECTED]
------------------------------------------------------------------------
---------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
