| 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: Another datafile sizing question
Darren - Let me try to clarify my answer.
1. Yes, 800-meg is not really large with today's disk systems, so that
consolidation should be no problem.
2. If you are doing this type of consolidation, I think it would be a good
time for you to take as step back for broader perspective. Specifically, it
might be a good time for you to take a look at LMTs. Most of us DBAs only
perform this type of reorganization every few years, so it is a good idea to
incorporate the latest thinking. One of the reasons Oracle is moving us
toward LMTs is to reduce the DBA workload, so the Microsoft heads can't keep
saying "not only is Oracle more expensive, but it takes a lot more
management."
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
-----Original Message-----
Sent: Wednesday, September 25, 2002 7:47 PM
To: 'ORACLE-L_at_fatcity.com'
Darren - My advice would be to read up on Locally Managed Tablespaces (LMT) and uniform extents. This is a new feature that will ease your management work.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, September 25, 2002 6:43 PM
To: Multiple recipients of list 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
--
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).
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). Received on Thu Sep 26 2002 - 10:48:39 CDT
 |
 |